Matt! And Eirikur! You are my heroes!
Eirikur, I see you were suggesting similar but I clearly did not interpret the converted emoticons back correctly.
But Matt, yours...

Hey, thanks so much for looking at this! I previously thought it might be best to just post enough of the XML Data to see the beginning of the relevant...

Thank you SO much all of you!

Wow, This last one blows my mind as well. Still trying to understand how the update of the CTE results in #PayRoll changing but from what I see so far...

Thank you. Will check this further then.

In context what I provide here is just a simplified version to illustrate the problem at hand, but I intend using this for a...

On the suggestion of using SQL Server's built-in windowing functions, such as OVER(), and LEAD/LAG, whilst I am using this on a 2008R2 version, I am still very interested to...

Fascinating and brilliant solution Alan. I really value your effort on this.

I do believe that there is one significant caveat with the Quirky Update (just love the name it has...

Thank you so much Alan. A fascinating concept. I might be overly tired but just cannot figure out how to apply the concept to my situation. But will continue figuring...

Thanks for posting but I think this has really sparked up the age-old question on whether there is a difference between COUNT(*) and COUNT(1). In my early days I believed...