Break column into row

[yolip]

Hi,

I am looking to break the following example into rows

Source:
loc1 loc2 loc3 loc4
12 9 19 22

Target:
loc1 12
loc2 9
loc3 19
loc4 22

Can anyone help? I have been checking pivot and unpivot, but still don't know how to do this.


Thanks
Yolip

[ComITSolutions]

Which Database SQL Server 2000,SQL Server2005 or oracle????

[yolip]

i am doing it in sql 2008

[yolip]

i am doing it in sql 2008

[ComITSolutions]

The following links may be useful
http://msdn.microsoft.com/en-us/library/ms177410.aspx
http://www.yafla.com/dennisforbes/UN...rver-2005.html