anthony.green (7/26/2012)
Thanks Gents, been one of them days and nothing gone right so far, so my heads not in the game.Gone with John's responce as its the simpler to impliment, just changed the -1 to a -2 to remove the comma and the space.
Cheers again gents.
if you are going to be using it for a function i would have a look at lynn's STUFF with FOR XML PATH as that could be put together into a iTVF. get an even bigger performance boost over the cursor.
EDIT: after looking at who i was responding to i am willing to hazard a guess that anthony knows that all ready.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]