Philippe Renaud
asked on
SQL Query problem
Hello EE,
I have a query results like this:
Name Level Key Description Jannuary February
Peter 3 P Peter's Sales 500 200
Isabel 3 P Isa's Sales 200 450
How could I do a new query the results be like this :
Key Peter Jan Peter Feb Isa Jan Isa Feb
P 500 200 200 450
(since both lines on first query was P) there is only 1 row on second query result and Vendors are horizontal. If there were 5 months they would have 5 months each...
is it possible ? ... thanks sql experts !!
I have a query results like this:
Name Level Key Description Jannuary February
Peter 3 P Peter's Sales 500 200
Isabel 3 P Isa's Sales 200 450
How could I do a new query the results be like this :
Key Peter Jan Peter Feb Isa Jan Isa Feb
P 500 200 200 450
(since both lines on first query was P) there is only 1 row on second query result and Vendors are horizontal. If there were 5 months they would have 5 months each...
is it possible ? ... thanks sql experts !!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Well if that is the case what you could do is use a stored procedure to construct the query in the same way. but then there will involve too many self joins, not too sure if that's a very efficient way.
There is one option of pivot tables but i don't thing it can be used in this scenario.
Exploring it, if i am able to get it will post it .
There is one option of pivot tables but i don't thing it can be used in this scenario.
Exploring it, if i am able to get it will post it .
ASKER
because tomorrow it could have 4 name (peter isa john mike) and the query wouldnt work anymore.. ?