Carl P. Anderson


SQLServerCentral Article

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: )

149,262 reads

Blogs

Hello world!

By

Welcome to WordPress. This is your first post. Edit or delete it, then start...

Daily Coping 2 Dec 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

SQL Homework – December 2021 – Changing collation

By

I can only speak for the locations I’ve worked at of course, but in...

Read the latest Blogs

Forums

how to identify BottleNeck by using the data of sys.dm_os_performance_counters

By 892717952

There are many many data to show the SQL Server current performance, May I...

SQL Query Help on Time based query

By dcw8888

I have a following table (Contains script to generate the sample table with data):...

When to Use a Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item When to Use a Database

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers