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