Script to Return a Transposed Data Row

I often do the following when administering databases "select * from Table where PrimaryKey=value" and find the output in Query Analyzer is inconvenient to view when the table has many wide columns (which is often the case). This script returns a single entry from a table but "transposed" so that the data flows down the […]

2005-11-10 (first published: )

224 reads

Blogs

Daily Coping 21 Jan 2021

By

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

It’s 2021, so why are you reading this?

By

If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....

Daily Coping 20 Jan 2021

By

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

Read the latest Blogs

Forums

Save results from Stored procedure to a CSV file.

By lee.hopkins

I have a SqlAgentJob calling a stored proc. that loops through a list of...

Search Report definitions

By dan-572483

I know that there is a query you can run in SQL to search...

Lookup and insert into column without dynamic SQL?

By kramaswamy

Hi all, 99% sure the answer to this question is "it is not possible",...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers