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

326 reads

Blogs

DBA Myths: The system sessions are the ones with a session_id 50 or less

By

Anecdotally any session_id that’s 50 or less is going to be a system session...

SQL Undercover TV – Encrypting SQL Backups

By

In this episode, David looks at how we can encrypt our SQL Server backup...

Using volumes in SQL Server 2019 non-root containers

By

I’ve seen a few people online asking how to use docker named volumes with...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

missing storage space

By MVDBA (Mike Vessey)

Hi I have a particular drive on one of my sql servers, it's gotten...

Issue with processing dimensions

By richardmgreen1

Hi all   I've got a weird one here. We have a multi-dimensional cube...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Leaving SQLCMD

See possible answers