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,211 reads

Blogs

What’s my MAC Address in a Command Prompt?–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

You don’t need a blockchain

By

After writing several posts about a neat feature in Azure SQL called system-versioned ledger...

Daily Coping 27 Oct 2021

By

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

Read the latest Blogs

Forums

Error connecting using AlwaysON Listener

By Arsh

Dear Friends, I have a 2-node Read-Scale Always ON Availability Group to which I...

How to get feature key and feature value separated $ based on part id ?

By ahmed_elbarbary.2010

I work on sql server 2012 i need to get featurekey and feature value...

Setting Up SQL Server 2019 for Optimal Performance

By water490

Hi I have a very large database (600GB) that I am looking at creating. ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers