pawankkmr 41145 (4/30/2015)
http://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/%5B/quote%5D
That's pretty cool. One recommendation would be that if anyone wants to use XML to do a split, you might not want to work for them. 😀
My other recommendation would be that it would really be helpful to neophytes if you provided code to generate, say, a million rows of sample data so that people can also learn about how to make such things fast.
--Jeff Moden
Change is inevitable... Change for the better is not.