Is it possible to convert rows to columns using CTE in sql server 2005 and i would like to know where will be using CTE and how it is implemented to real time situtions.I am bit confuesd how to used it .

http://www.4guysfromrolla.com/webtech/071906-1.shtml

If you want to convert rows into columns check out the PIVOT operator

http://technet.microsoft.com/en-us/library/ms177410.aspx

Thanks

Dev

You can use PIVOT or you can use Case statements to do your move if you can.