Click here to Skip to main content
12,397,805 members (52,522 online)
Rate this:
 
Please Sign up or sign in to vote.
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 29-Apr-13 23:54pm
Updated 30-Apr-13 0: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 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 30 Apr 2013
Copyright © CodeProject, 1999-2016
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