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: 202
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.
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