Hi,
I have a expenses table, in this table I have the account, exp_date,
exp_type and amount fields.
I have three exp_type (real, budget and myu) I would like to create a table
with
the fileds account, year_month, real_amount, budget_amount and myu_amount.
I am kind of lost now. How can I do this?
Will it be a query?
do a have a ETL process if yes, how will it work?
Thanks
Search the google archives of microsoft.public.sqlserver.programming group
with the keyword "pivot" and "crosstab" and you will end up with several
solutions posted for similar questions.
Anith
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment