RE: [OT] How to transpose a table in MS SQL Server 2000

2005-04-08 Thread Paul McCulloch
2 > To: Struts Users Mailing List > Subject: RE: [OT] How to transpose a table in MS SQL Server 2000 > > > id/ID are synthetic keys and can be ignored (as well as > 'total'). So, the > simplified case is: > > source_table >

RE: [OT] How to transpose a table in MS SQL Server 2000

2005-04-08 Thread DGraham
L COL1COL2 month jan feb val11 3 val22 4 Thanks, Dennis Paul McCulloch <[EMAIL PROTECTED]> 04/08/2005 10:47 AM Please respond to "Struts Users Mailing List" To 'Struts Users Mailing List' cc Subject RE: [OT] How to transpose a

RE: [OT] How to transpose a table in MS SQL Server 2000

2005-04-08 Thread Paul McCulloch
ED] > [mailto:[EMAIL PROTECTED] > Sent: 08 April 2005 14:46 > To: Struts Users Mailing List > Subject: [OT] How to transpose a table in MS SQL Server 2000 > > > So, I have the following table: > > id month val1val2total > 1 jan 1 2

[OT] How to transpose a table in MS SQL Server 2000

2005-04-08 Thread DGraham
So, I have the following table: id month val1val2total 1 jan 1 2 3 2 feb 3 4 7 And I'd like it transformed to: ID VAL COL1COL2 1 month jan feb 2 val11 3 3 val22 4 4 total