CROSS TAB QUERY in SQL ...need help 1

[prams]

I have read about the CASE operator but i wasnt able to get the output in the way i wanted.
Here is my table structure:

Project Month Forecast

x Jan 5
x Feb 6
x Mar 5
y Jan 10
y Feb 12
y Mar 14

and i want the output something like this

Project Jan Feb Mar
x 5 6 5
y 10 12 14

and so on.

I tried using the CASE operator and got 1 for each of the forecast value because it counted the records.

could anyone help me on this.

Thanks in advance

 

[Andel]

Try this...

select proj,
Sum(Case When Mo = 'Jan' then forcast end) as Jan,
Sum(Case When Mo = 'Feb' then forcast end) as Feb,
Sum(Case When Mo = 'Mar' then forcast end) as Mar
From Table
group by proj
Andel
andelbarroga@hotmail.com

http://andyb.8m.com