Click here to Skip to main content
11,411,922 members (61,403 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 OriginalGriff 268
1 Sergey Alexandrovich Kryukov 200
2 Sascha Lefévre 170
3 ProgramFOX 130
4 Maciej Los 110
0 Sergey Alexandrovich Kryukov 8,955
1 OriginalGriff 7,158
2 Maciej Los 3,480
3 Abhinav S 3,248
4 Peter Leow 3,059


Advertise | Privacy | Mobile
Web01 | 2.8.150414.5 | 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