Dublettencheck über mehrere Spalten?

[Bummi]

dann vielleicht in der Art, oder ähnlich ...

Code:

Select * 
,Case When (Select Top 1 ID from Adressen ai where ai.Name=t.Name ...... Order by ModiTimeStamp) = t.ID then 0 else 1 end as FlagFuerAelter
from Adressen t
join (
Select Name,Vorname,Strasse,Count(*) as Anz
from Adressen
Group by Name,Vorname,Strasse
Having Count(*)>1
) a
on a.Name=t.Name and a.Vorname=t.Vorname and a.Strasse=t.Strasse
order by t.name,t.Vorname,t.Strasse