Home Forums SQL Server 2005 T-SQL (SS2K5) Count technicians passing on a call RE: Count technicians passing on a call
John Mitchell-245523
SSC Guru
Points: 148809
More actions
June 26, 2013 at 3:37 am
#1627445
That's a good start. Now you need to join that result set to itself on callref = callref and rn = rn + 1, counting the number of times that the two repids are different.
John