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

MS Sql Server LazyDBA home page