Hi,

I'd use rownumber() to do that. Given what you've described then this should do the trick:

SELECT

x.TargetID, x.TargetName, x.Interaction, x.Created

FROM

(

SELECT

*, ROW_NUMBER() OVER (PARTITION BY TargetName, [Interaction] ORDER BY [Created]) AS Occurrance

FROM #Visits

) AS x

WHERE

x.[Occurrance] = 1

AND [x].[Interaction] = 'target_acquired'

DROP TABLE #Visits