Steve


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

332 reads

Blogs

Logging Messages with Raiserror – #SQLNewBlogger

By

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

Daily Coping 8 Mar 2021

By

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

Webinar – Building a Proper SQL Server Database Security Model

By

Tomorrow, March 9, 2020, at 3 PM EST, I will be giving a presentation...

Read the latest Blogs

Forums

SSRS report download fails

By Tomys

Hi. I am trying to download a report from SSRS 2019 in word format...

Many executionplans for one query, why?

By oRBIT

I've yet to find an answer for this. I've found a few queries that...

Index on View

By AMCiti

Dear Group: I was going to create an index on a view we have,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers