Sturev (5/25/2016)
TheSQLGuru (5/25/2016)
Come now - I know you could have figured this one out by extending what I had!! 😛You scared the crap out of me with that second post w/DENSE_RANK, CHECKSUM, ETC... 😀
Looks awesome, I'm going to give that a test run here in a bit! Thanks again for jumping in on this; much appreciated!
That other example wasn't my solution - that was Eirikur Eiriksson. He likes to show off sometimes. :hehe:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service