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 ...