Click here to Skip to main content
11,488,877 members (77,045 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-server-2005
Hello,

I have a table that have records like this -



Particluar-------------------------------------Amount

Excise Duty 12 % ---------------------------- 2775.00
Edu CESS 2% -------------------------------- 56.00
HR Edu CESS 1% ---------------------------- 28.00
Sale CST 2% --------------------------------- 520.00

and I would like to get the following from select query

Excise Duty 12 % ---- Edu CESS 2% ---- HR Edu CESS 1% ---- Sale CST 2%
2775.00 ----------------- 56.00 ------------- 28.00 ------------- 520.00


If it possible then please reply me its urgent...
Thanx in advance....
Posted 30-Apr-13 0:54am
Edited 30-Apr-13 1:00am
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

You can try like this:-


declare @columns varchar(max)
declare @convert varchar(max)
select @columns =stuff((select '],[' + particular from tblName order by '],['
                                   + convert(varchar(max),points) desc
                                     for xml path('')),1,2,'') + ']'
 
--Select @columns column

 set @convert= 'select * from (select * from tblName) contributors
                            pivot (sum(points) for particulars in (' +@Columns + ')) as                               pivottbl'
 

--select @convert
execute (@convert)
  Permalink  
Comments
bburhanbohra at 30-Apr-13 6:46am
   
Thank You so much...solution works...
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

PIVOT may help for your problem. Please try it.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 499
1 OriginalGriff 328
2 _Asif_ 155
3 Sascha Lefèvre 135
4 _duDE_ 121
0 Sergey Alexandrovich Kryukov 9,308
1 OriginalGriff 8,375
2 Sascha Lefèvre 3,334
3 Maciej Los 2,996
4 Richard Deeming 2,370


Advertise | Privacy | Mobile
Web01 | 2.8.150520.1 | Last Updated 30 Apr 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100