?
Solved

Script to convert rows into column or vice-versa

Posted on 2004-09-08
2
Medium Priority
?
8,713 Views
Last Modified: 2010-05-18
I need command or script to convert rows into columns or vice-versa in MS SQL 2000. Any one has ideas or commands?
0
Comment
Question by:rsrsm
2 Comments
 
LVL 26

Expert Comment

by:Hilaire
ID: 12004160
Should it be a new table or just a query to make a pivot table ?
Please post sample data, current shape + expected results.

With the information you have given so far, the best I can come with is
- issue a select * in QA
- copy output to an excel file
- use Excel rotate functionality
- change column names at will
- import xl file into a new table using DTS
0
 
LVL 5

Accepted Solution

by:
g0rath earned 750 total points
ID: 12005529
Here is a pivot table stored procedure that I've used and works fairly well.
http://www.sqlteam.com/item.asp?ItemID=2955

Lately I've hand coded these by hand to insure I know what they are doing.
0

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

585 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question