Change Result Set Columns to Rows

I had a developer in my company come to me recently with a unique request.  He asked if there was any way for sql to return a result set that was flopped.  In other words he wanted the rows to be columns and the columns to be rows.  So that a result set like this:Col1    […]

2004-07-19 (first published: )

320 reads

Blogs

Last Weeks Reading (2019-05-26)

By

It was tremendously extensive week for me (a week ago) when I spent time...

Migrating SSIS to Azure – Slidedeck (Techorama 2019)

By

Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...

Containers: Create a Custom Container

By

Creating a custom container is where things get truly exciting. There’s actually a ton...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Proverbial Tree Barking

By maverickuk82

Hi All, I'm just after a pointer really. I've had an idea. I want...

Transforming rows into columns

By rkarr7

Hi Everyone, I have a table with the structure as attached in the Table...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers