Cursor? But what are you going to do when the string you're building gets into text length?
All of a sudden normalized data become useless.

P
-----Original Message-----
From: Anand Kumar ( IS )
[mailto:mssqldba-ezmlmshield-x25832976.[Email address protected]
Sent: Wednesday, June 29, 2005 6:45 AM
To: LazyDBA Discussion
Subject: Transpose Problem


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.

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


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

MS Sql Server LazyDBA home page