How do I do pivoting in this query in SQL?
- by dewacorp.alliances
Hi there
I have this table like this:
Name; Amount1, Amount, Rate1, Rate2
Test; 1000; 2000; 1.0; 2.0
I want to display into:
Parameter; Amount1; Rate1; Total
'Parameter 1'; 1000; 1.0; 1000
'Parameter 2'; 2000; 2.0; 4000
BTW ... I am using SQL2K5. All I can think of is CURSOR. Any other solution in elegant way?
Thanks