how to convert row into colun in sql server ?

hi,

it depend upon your requirement.
you just want to convert whatever row you have in to column or you want to perform some aggregate option on row while converting to column.

you can use pivot query in the second case.

http://msdn.microsoft.com/en-in/library/ms177410%28v=sql.105%29.aspx

http://blogs.msdn.com/b/spike/archive/2009/03/03/pivot-tables-in-sql-server-a-simple-sample.aspx

hope this will help you.