Recently Adam Machanic issued a fresh SQL challenge based upon concatenating string data. The results are now in. Although I was eliminated in the first round, appeal lodged :) , just looking at the execution times mine were pretty damn quick. I feel particularly good as entries by Itzik Ben-Gan were slower than mine.