Convert columns to rows

Convert columns to rows

hi,
I need to convert columns to rows

here i have sample input data

weekno    manager1 	manager2
51 	 33454 	        26749
52 	  33454 	26749	

i wnat the output like this

weekno manager

51 	 33454 	
51       26749
52 	 33454 
52	 26749	

colud u please help me out how to go about this and if any query to do so. Received on Wed Mar 31 2004 - 05:28:04 CST