Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
meeram
Starting Member
2 Posts |
 Posted - 2011-09-24 : 04:08:39
|
| HiI am having the table like belowServiceID ServiceName HeaderName Value1 Service1 Test 101 Service1 Team 201 Service1 Header 301 Service1 xxxx 401 Service1 yyyy 50and I want the result like belowServiceID ServiceName Test Team Header Xxxx Yyyy1 Service1 10 20 30 40 50Please help me to achieve this.Thanks,Ramasamy |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-24 : 04:28:52
|
| [code]SELECT ServiceID,ServiceName,MAX(CASE WHEN HeaderName = 'Test' THEN Value ELSE NULL END) AS Test,MAX(CASE WHEN HeaderName = 'Team' THEN Value ELSE NULL END) AS Team,MAX(CASE WHEN HeaderName = 'Header' THEN Value ELSE NULL END) AS Header,MAX(CASE WHEN HeaderName = 'Xxxx' THEN Value ELSE NULL END) AS Xxxx,MAX(CASE WHEN HeaderName = 'Yyyy' THEN Value ELSE NULL END) AS Yyyy FROM tableGROUP BY ServiceID,ServiceName[/code]------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
meeram
Starting Member
2 Posts |
Posted - 2011-09-24 : 04:35:02
|
| Hi,My Header column value is not fixed, so need to create columns dynamically based on the rows. "CASE" we can use only for the fixed values. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Rows to Columns