Sql Select Query

Question

0.00/5 (No votes)

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 29-Apr-13 23:54pm

bburhanbohra

Updated 30-Apr-13 0:00am

v2

Add a Solution

2 solutions

Solution 1

PIVOT may help for your problem. Please try it.

Posted 30-Apr-13 0:10am

SLNS001

Add a Solution

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

TrushnaK · Accepted Answer · 2013-04-30T00:22:00

You can try like this:-

SQL

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)

Sql Select Query

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Sql Select Query

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us