Custom aggregate functions

• Iulian -207023

  SSCertifiable

  Points: 7639

  More actions

  November 29, 2011 at 4:40 pm

  #263766

  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

• Evil Kraig F

  SSC Guru

  Points: 100851

  More actions

  November 29, 2011 at 4:56 pm

  #1414392

  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/

  ---

  - Craig Farrell

  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