Combining values into comma separated list - serialize

• vecerda

  SSCrazy

  Points: 2532

  More actions

  April 18, 2014 at 1:29 pm

  #285888

  Hi,

  I have a requirement for SSRS where the input has the following structure:

  Store NumberStore Owner

  542 Jaklin Givargidze

  542 Raymond G. Givargidze

  557 Hui Juan Lu

  557 Tong Yu Lu

  but the user would like to see the following:

  Store Number

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  April 18, 2014 at 2:14 pm

  #1707185

  duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1563159-3077-1.aspx

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/