• I was just making the observation that the original post did not say where the data was coming from or where it was going. However clever the T-SQL solutions are, I saw no mention of the possibility of any other method. There were no questions about the data source, destination, or number of rows.

    Usually in these forums I see a lot of enlightened discourse about possible gotchas or other aspects of a problem that would never occur to me, and find it very informative. This time I felt the proposed solutions may not have had enough variety. I doubt that most of you would have any trouble implementing the script transform I described, it's not a shockingly clever idea. It just seemed to have been overlooked.