-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: Manikandan.Appar
Message 3 in Discussion
Hi Sethu,
Try this method
Declare @strValue Varchar(1000)
Set @strValue = ''
Select @strValue = @strValue + ',' + ColumnName from table_Name;
Print @strValue;
Select @strValue;
thanks,
Manikandan.
On 11/14/06, r_sethu <[EMAIL PROTECTED]> wrote:
New Message on BDOTNET
SQL Query - Row as a single column...?
Reply
Reply to Sender
Recommend
Message 1 in Discussion
From:
r_sethu
I am using SQL 2000. Assume I have a table as below.
ID
101
123
112
103
I want to get the output from a selection statement:
101,123,112,103
Is it possible to get this output using a single select statement without using
any loop?
(Incase, the table have 'n' rows the values should be same like a semicolon
seperated single string.)
Regards,
R.Sethumadhavan.
View other groups in this category.
Also on MSN:
Start Chatting |
Listen to Music |
House & Home |
Try Online Dating |
Daily Horoscopes
To stop getting this e-mail, or change how often it arrives, go to your
E-mail Settings.
Need help? If you've forgotten your password, please go to
Passport Member Services.
For other questions or feedback, go to our
Contact Us page.
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
Remove my e-mail address from BDOTNET.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
