Matt Miller (11/15/2007)
Gail - as to your test - I will try to dig out and use the XML data() trick, we'll let Jeff come up with the "pure" T-SQL trick, and you can handle the CLR?
I can try. I'll hopefully find 5 min today. I can't promise it will be the best performing CLR out there. I'm still much a novice with C
Sorry, things are just rather hectic right now.
Edit: i see Matt beat me to it. 😀
I thought that was how the XML trick worked. There's some very nifty tricks that can be dome with the new XML features. I particuarly like FOR XML TYPE in a subquery.
Jeff, I'm going to steal that concat function from you. I normally resrt to temp tables and cursors. :pinch:
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass