select top(100) percent
ID
,AddressID
from
(
SELECT
ID
,rn = row_number() over (partition by ID order by ID, AddressID)
FROM [dbo].[Fac]
INNER JOIN [dbo].[FacAddress] ON Fac.ID = FacAddress.ID
) A
where (a.rn = 1)
order by FacilityID
Never in the field of human conflict was so much owed by so many to so few. All our hearts go out to the developers, whose brilliant actions we see with our own eyes day after day…