Convert Rows into Columns... (Cross tab).

Convert Rows into Columns... (Cross tab).

• Ashyura Bin Ismail

  You can also select the cells, copy, shift F10, select paste and transpose. The selected rows will copy in columnar form.

  Good Luck

  
  
  

• philcava

  Jon:

  What version of SQL Server are you using Also, a cursor is NOT normally a good idea. Take a look at some of these posts:

  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1372104&SiteID=1
  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=892822&SiteID=1
  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=447559&SiteID=1
  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=437891&SiteID=1
  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=588762&SiteID=1
  

  Please open a new thread and post what you are trying to accomplish.

  
  

• Cloudie

  Mark's response is why I want you to post a new thread. Sorry, Mark. Should I split this thread
  

• jmwendt24

  You can try "Pivot transformation". Book online has examples.
  

• Mazz2000

  Hi,

  I also have a same problem. Can you suggest what was your solution

  regards

  Josh

  
  

• tidanone

  I also need to do something similar...

  It was suggested that I would probably need to use a cursor in a stored procedure which loops through the rows and updates a temporary table with the values I need.

  I haven’t got round to doing this yet… so if anybody has a solution which I could have a look at I’d be very grateful.

  I’ll post my solution when I’ve got it.

  
  

• Bobby Ortiz

  Thanks for the links kent.

  I have managed to solve my problem.

  
  

• Roland Burt

  select [Month],
  max(case when [Status]='I' then [Count] end) as I,
  max(case when [Status]='O' then [Count] end) as O,
  max(case when [Status]='S' then [Count] end) as S
  from mytable
  group by [Month]
  order by [Month]

  
  
• Convert Rows into Columns... (Cross tab).