SQL Server Forums - insert problem

Home | Weblogs | Forums | SQL Server Links

SQL Server Forums

Register Now and get your question answered!

All Forums

Old Forums

insert problem

Forum Locked

Author

Topic

mitasid
Yak Posting Veteran

New Zealand
51 Posts

Posted - 06/14/2006 : 19:23:31

Hi i want to convert rows to columns in my table.
my rows are jan,feb,mar,apr,.....dec
i want to convert them into columns

how shall i do that?????

nosepicker
Constraint Violating Yak Guru

USA
366 Posts

Posted - 06/14/2006 : 20:39:46

Use the CASE statement:

SELECT
CASE WHEN YourColumn = 'jan' THEN ... END AS [jan],
CASE WHEN YourColumn = 'feb' THEN ... END AS [feb],
...

madhivanan
Premature Yak Congratulator

India
22469 Posts

Posted - 06/15/2006 : 03:00:48

Read about Cross-tab Reports in sql server help file
Also refer
http://weblogs.sqlteam.com/jeffs/archive/2005/05.aspx

Madhivanan

Failing to plan is Planning to fail

Topic

Forum Locked

Jump To:

SQL Server Forums

This page was generated in 0.05 seconds.