Click here to Skip to main content
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)



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