Hi

This should do the trick for you

with cte as (

select PhoneNum, PhoneType, PhoneLocation, FileDate

,ROW_NUMBER() OVER (PARTITION BY PhoneNum ORDER BY PhoneType, PhoneLocation, FileDate) -

ROW_NUMBER() OVER (PARTITION BY PhoneNum ORDER BY FileDate) R

FROM #A

)

SELECT PhoneNum, PhoneType, PhoneLocation, Min(FileDate), max(FileDate)

FROM cte

GROUP BY PhoneNum, PhoneType, PhoneLocation, R

ORDER BY PhoneNum, Min(fileDate);