Home Forums SQL Server 2008 SQL Server 2008 - General Partition by or Row num or Subquery - Assistance RE: Partition by or Row num or Subquery - Assistance
John Mitchell-245523
SSC Guru
Points: 148809
More actions
July 17, 2017 at 6:45 am
#1951129
Yes, I get the gist of what you're trying to do, but you still need a tiebreaker for rows that have the same CompletedDate. Why not include the time portion in that column? That would enable you to see what happened first.
John