convert columns to rows in sql

		Wrox Programmer Forums > Database > SQL Language
convert columns to rows in sql

SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

January 2nd, 2007, 02:04 AM

hoangmv0101 hoangmv0101 is offline

Registered User

Join Date: Jan 2007

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

convert columns to rows in sql

I have table
STOCK THINGS COUNT PRICE
STOCK1 A 20 200
STOCK1 B 10 150
STOCK2 A 15 100
STOCK3 B 12 250
STOCK4 C 11 150
..... .... .... ...
STOCKn N ... ...
and I want to convert to
THINGS STOCK1COUNT STOCK1PRICE STOCK2COUNT STOCK2COUNT .........
A 20 200 15 100
B 10 150 0 0 ..........

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL Query to Convert Columns into Rows	Niaz	Oracle	3	February 5th, 2010 07:08 AM
SQL Query to convert Columns into Rows....again	phix	SQL Server 2000	11	November 11th, 2007 09:59 AM
sql - concating columns for rows with same ID	yuvalk	SQL Server 2000	6	September 26th, 2006 10:47 AM
Formatting sql query rows as columns with stack	sastian	PHP Databases	0	March 25th, 2005 04:51 AM
SQL Query to Convert Columns into Rows	Niaz	SQL Server 2000	2	April 20th, 2004 01:36 AM