Concatenating Rows

Posted on SQL Server Central See other posts from SQL Server Central
Published on Fri, 04 Mar 2011 07:00:00 UT Indexed on 2011/03/10 8:16 UTC
Read the original article Hit count: 198

Filed under:
Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this.
SQL Backup Free trial of SQL Backup™
“SQL Backup was able to cut down my backup time
significantly AND achieved a 90% compression at
the same time!” Joe Cheng. Download a free trial now.

© SQL Server Central or respective owner