Carl P. Anderson

Concatenating Rows

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.

3.39 (100)

2011-03-04 (first published: )

148,335 reads

Blogs

Sorting in Stored Procedures – Food for Thought

By

We know that sorting can be one of the most expensive things in an...

Insperation

By

Inspiration: The process of being mentally stimulated to do or feel something, especially to...

Trace Query in Extended Events

By

The ability to quickly and easily trace a query is important to database professionals....

Read the latest Blogs

Forums

Replication causing log bloating

By tarr94

Hello, We've had a replication process in place for several years.  It seems like...

How to import Excel with XML

By itmasterw 60042

Hi, I have an Excel sheet that I have to import into SQL Server....

Recursive CTE - Batches

By koti.raavi

Hi Folks I'm trying to group rows into batch and adding batch to query...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers