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
I don't 100% understand your tables. Where does ID come from (the values 1 & 2 exist in the first view, but 1,2,3,4 in the second). Are the totals derived? Give me the SQL for the first view and I'll have a look. Paul > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTE