How do i assign a CSV value to a variable

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

How do i assign a CSV value to a variable

Author

Topic

mary_itohan
Posting Yak Master

191 Posts

Posted - 2008-09-08 : 18:34:40

Hello,

How do i assign a CSV value to a variable. Here is my code


declare @sally varchar(8000)
set @sally = (select receipient from sms_history )

thanks

Yes O !

nathans
Aged Yak Warrior

938 Posts

Posted - 2008-09-08 : 22:10:12

examples of constructing the csv are all over this site. here are a few: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=15651

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources