November 29, 2011 at 4:40 pm
Hello,
I need an aggregate function that concatenate string values on a column.
The msdn example here (the first one) does exactly what I need.
My questions are:
What is the order of the rows the strings concatenates?
How can I make sure the order of the strings being concatenated is the one I need?
for example I need the concatenated strings to be ordered by a date column
Thank you,
Iulian
November 29, 2011 at 4:56 pm
You're going to want to use the FOR XML method, just without a delimited separator.
Check out this article: http://www.sqlservercentral.com/articles/FOR+XML+PATH/70203/
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy