Try

SELECT A.Billno as Bill_No, A.Tax_Val as TaxValA, B.Tax_Val as TaxValB,
C.Tax_Val as TaxValC
FROM (SELECT BILLNO, TAX_VAL FROM table_name_here WHERE Tax_Desc =
'a') as A LEFT JOIN
(SELECT BILLNO, TAX_VAL FROM table_name_here WHERE Tax_Desc
= 'b') as B
ON A.BILLNO = B.BILLNO LEFT JOIN (SELECT BILLNO,
TAX_VAL FROM table_name_here WHERE Tax_Desc = 'c') as C
ON B.BILLNO = C.BILLNO

-----Original Message-----
From: Jayprakash
[mailto:mssqldba-ezmlmshield-x55664323.[Email address protected]
Sent: Thursday, June 28, 2007 1:18 AM
To: LazyDBA Discussion
Subject: please help

i have output of a table like.

billno tax_desc tax_val
-----------------------------------------------
1 a 11
1 b 12
1 c 13
2 a 14
2 b 15
2 c 14
. a -
. b -
. c -
i need the output as

bill_no taxvala taxvalb taxvalc
----------------------------------------
.1 11 12 13
2 14 15 16
pleas help

Regards,
Jayprakash Mandle,
Sr Executive - IT,
Henkel CAC Pvt Ltd


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page