Hi Gurus,
need an urgent help.
I have got a table Called "Nominee"
The values are like this

Id Name Age
1 Anand 27
2 Joe 30
3 Mac 29

I want the transpose it and the data should look like

1 Anand 27 2 Joe 30 3 Mac 29


Any help would be appriciated..

Regards
Ananda Kumar



#####################################################################################
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege
is waived or lost by any mistransmission. If you receive this message in error,
please immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender. You must not, directly or indirectly,
use, disclose, distribute, print, or copy any part of this message if you are not
the intended recipient. TransWorks Information Services Ltd. and any of its subsidiaries each reserve
the right to monitor all e-mail communications through its networks.

Any views expressed in this message are those of the individual sender, except where
the message states otherwise and the sender is authorized to state them to be the
views of any such entity.

#####################################################################################

MS Sql Server LazyDBA home page