Thanks Ron for this great question today as well. It required a little bit of reading before attempting it.
Happy that I got it correct in the end 🙂
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter