RE: SQL Pivot

Dave --
 
My SQL Server 4.21 manual, page 162, details how to do this.
 
I don't have it here; it's at home. I'll send the details on Wednesday
morning if no one else answers before then.
 
-- Don Schenck

-----Original Message-----
From: Leland, David [mailto:dleland@Harter.com]
Sent: February 01, 2000 11:15 AM
To: 'MIDRANGE-L@midrange.com'
Subject: SQL Pivot



Somewhere, a long time ago, I read a message detailing how to write an SQL
statement that would do something on the order of an Excel Pivot function.
For example, I would like to print a year's worth of transactional data in
12 monthly columns - across the page, not down.

Anyone recall how to do that? 

The file contains:  ITNBR (15 char), TRANDATE (*DATE), QTY (7,0 packed). 

I would like it to print out as: 

Item____________      Jan.       Feb.        Mar.,   etc. 
XXXXXXXXXXXXXXXX  X,XXX,XXX  X,XXX,XXX  X,XXX,XXX 

Thanks, 
Dave 

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---