How To Stop Data Redundancy

Hey guys...i've got a problem wif my stored procedures...in which my page keep repeating the same data...so to counter this problem i use SELECT DISTINCT instead of just SELECT..but the problem is when i change SELECT into SELECT DISTINCT...the page will not be display,page error....for your information my stored procures was auto generate from some security sofware...so can guys help me out with my code...

SELECT DISTINCT t.TargetID,
 'V' RecordType,
 t.TargetDNSName [Target DNS Name],
 t.TargetIPAddress [Target IP],
 t.TargetIPDisplay [Target IP Display],
 t.TargetOSName,
 t.TargetOSRevisionLevel,
 v.SecChkID,
 v.Severity,
 sc.TagName [Tag Name],
 sc.ChkBriefDesc [Tag Brief Desc],
 sc.ChkName [Tag Chk Name],
 CONVERT(NVARCHAR(4000),sc.ChkDetailDesc) [Tag Detail Desc],
 CONVERT(NVARCHAR(4000),r.RemedyDesc) [Remedy],
 o.ObjectID,
 o.ObjectTypeDesc [Object Type Desc],
 o.ObjectName [Object Name],
 s.SensorDataID,
 a.AttributeName,
 a.AttributeValue,
 NULL [Port],NULL [Service Name],NULL [Protocol] 

FROM #Vulns v
 INNER JOIN TargetHost t (NOLOCK)
 ON v.TargetID = t.TargetID
 INNER JOIN (SecurityChecks sc (NOLOCK)
  LEFT OUTER JOIN Remedies r (NOLOCK)
  ON sc.SecChkID = r.SecChkID)
 ON v.SecChkID = sc.SecChkID
 INNER JOIN ObjectView o (NOLOCK)
 ON v.ObjectID = o.ObjectID
 LEFT OUTER JOIN SensorData1 s WITH (NOLOCK, INDEX(SensorData1_AK3))
 ON v.ObservanceID = s.ObservanceID
 AND s.Cleared = 'n'
 LEFT OUTER JOIN SensorDataAVP a (NOLOCK)
 ON s.SensorDataID = a.SensorDataID
 AND a.AttributeValue IS NOT NULL
 AND a.AttributeValue != ''
UNION ALL