On which server you are working sql 2000, or 2005.
Regards,
Subhash
-----Original Message-----
From: Sandesh.segu
[mailto:mssqldba-ezmlmshield-x39664967.[Email address protected]
Sent: Thursday, June 28, 2007 11:58 AM
To: LazyDBA Discussion
Subject: RE: please help
Please be clear :-)
==+==+==+==+==+==+==+==+==+==+==
Cordially,
Sandesh S
==+==+==+==+==+==+==+==+==+==+==
-----Original Message-----
From: Jayprakash
[mailto:mssqldba-ezmlmshield-x55664323.[Email address protected]
Sent: Thursday, June 28, 2007 11:48 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
------------------------ DISCLAIMER ------------------------ The
information contained and transmitted by this e-mail is proprietary to SLK
Software Services Private Limited and is intended solely for the use of the
individual or entity to whom it is addressed and others authorized to
receive it. It may contain privileged or confidential information or
information exempt from disclosure as per applicable law. If you are not
the intended recipient or responsible for delivery to the intended
recipient, you may not copy, deliver, distribute or print this message. If
it is a forwarded message it may not have been sent with the authority of
the company. Any views of opinions are individual to the sender and are not
the opinion of or endorsed by the company. This message and attachments has
been virus checked. SLK Software Services Pvt. Ltd. will not accept any
claims for loss or damages arising out of viruses.
---------------------------------------------------------------------
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