SQL Server Performance

Is it possible to convert rows to columns using CTE in sql server 2005

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by mahesh2006, Aug 23, 2008.

  1. mahesh2006 New Member

    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 .
  2. Madhivanan Moderator

  3. Kobojunkie New Member

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

Share This Page