Viewing 2 posts - 1 through 2 (of 2 total)
This looks like it would be a good fit for a CTE using a partition.
;WITH DEDUPE_CTE AS (select Location,StartDate,EndDate,Site,ROW_NUMBER()...
August 3, 2017 at 4:12 pm
#1954059
#1954058