Hello everybody!
I need your help with getting the result from a select statement in ms sql, that returns 8 rows, with 4 different values. What I want to have is one row with 9 values.
This is how the result looks today:
Region------------Year-------Quantity
1-Stockholm----2003---------59
2-Gothenburg---2003---------22
1-Stockholm----2004---------33
2-Gothenburg---2004---------44 etc...
This is how I want it to look:
Region---------- 2003---------2004--------2005
1-Stockholm-----59------------33-----------50
2-Gothenburg----22------------44-----------21
Any help with this would be much appreciated.
Sincerely
Richard Hellstenius
I need your help with getting the result from a select statement in ms sql, that returns 8 rows, with 4 different values. What I want to have is one row with 9 values.
This is how the result looks today:
Region------------Year-------Quantity
1-Stockholm----2003---------59
2-Gothenburg---2003---------22
1-Stockholm----2004---------33
2-Gothenburg---2004---------44 etc...
This is how I want it to look:
Region---------- 2003---------2004--------2005
1-Stockholm-----59------------33-----------50
2-Gothenburg----22------------44-----------21
Any help with this would be much appreciated.
Sincerely
Richard Hellstenius
Comment