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
>
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
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
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
4 matches
Mail list logo