Want results in columns not rows

[awaria]

SQL Server 2000 Enterprise SP3

I have a budegt table that has a row record for each budget month for each GL account. 12 rows per GL Account
I want to write a query that will return 1 row per glaccount with a column for each periodid.

Table structure is;
BudgetID, GL Acct, PeriodID, Budget Amount.

Need help with query to "pivot?" the 12 periodid and balances into columns.

Thanks,

Andrew

 

[PWise]

Select PeriodID,
Sum (Case When GL Acct = 1 then Budget Amount else 0 end ),
Sum (Case When GL Acct = 2 then Budget Amount else 0 end ),
Sum (Case When GL Acct = 3 then Budget Amount else 0 end ),
Sum (Case When GL Acct = 4 then Budget Amount else 0 end ),

Sum (Case When GL Acct=99999 then Budget Amount else 0 end)
From TableName
Group by PeriodID

 

[awaria]

PWise, thanks for the reply. I think I would want the case when to be th eperiodids to get the results to display as such;


gl acct period 1 per2 per3 . . .
111-1111 $40 $30 $45
222-2222 $20 $20 $30

Should the group by be GL Acct?

Can I simply switc out GL ACCT in the case when for periodid,
and the group by Gl Account?

Thanks for help input.

Andrew

 

[awaria]

That did it. It works great.

Thanks for providing the proper scripting and syntax.

Andrew