|
deanblaster
Starting Member
USA
2 Posts |
 Posted - 08/10/2008 : 17:03:46
|
Hi all... I'm new to this forum, and am a beginner to SQL querying.
Hopefully I can describe this in a way that makes sense.
There's a table I'm working with containing budgeting information that features a column for each month with a dollar amount.
I'd like to get a result set that has one line for each months amount.
Here's an example of the way it looks:
ACCOUNT_NAME, FISCAL_YEAR, BGT_SEPT, BGT_OCT, BGT_NOV
Travel Expenses, 2008, $1,500.00, $2,000.00, $2,500.00
Entertainment Expenses, 2008, $5,200.00, $5,350.00, $5,125.00
Here's an example of how I'd like my result set to look:
ACCOUNT_NAME, FISCAL_YEAR, FISCAL__PERIOD, BGT_AMT
Travel Expenses, 2008, 9, $1,500.00
Travel Expenses, 2008, 10, $2,000.00
Travel Expenses, 2008, 11, $2,500.00
Entertainment Expenses, 2008, 9, $5,200.00
Entertainment Expenses, 2008, 10, $5,350.00
Entertainment Expenses, 2008, 11, $5,125.00
Can someone please help me form a SELECT statement that would do this? I'm guessing I have to use a CASE statement.
Thanks in advance from a frustrated beginnner :)
|
|
UnPivot a Pivoted SQL Table
