I've got a a table that looks similar to this:
Desc, Jan, Feb, Mar, Apr, May, June, July, Aug, Sep, Oct, Nov, Dec
The month fields contain dollar amounts. I need to get the dollar amounts
into a single column and each in their own record. The data will be imported
from one sql db to another one using sql -- so I'm hoping for a way to
accomplish this using an sproc or a sql statement. Let's say I have a data
set that looks like this:
Record 1: Outside Sales, 100, 400, 300, 400, 500, 600, 200, 100, 200, 100,
Record 2: Intrasales, 200, 200, 200, 300, 150, 700, 100, 0, 100, 200, 200,
I want to convert it to look like this dataset (Desc, amount, month):
Record 1: Outside sales, 100, Jan
Record 2: Outside sales, 400, Feb
Record 3: Outside sales, 500, Mar
Record 4: Outside sales, 600, Apr
Is there a way I could accomplish this using a sql statement?
Thanks for any help or advice.