Storing the Result into a variable w/o Cursor

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

General SQL Server Forums

New to SQL Server Programming

Storing the Result into a variable w/o Cursor

Author

Topic

PoojaJ
Starting Member

10 Posts

Posted - 2007-02-01 : 01:23:36

Hello All,

A select statement returns one column with more than one rows.Is there a way to store it in sql Variable without using a Cursor.

Thank you in advance

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-01 : 01:25:45

concat the value and store in comma delimited string

Take a look here
http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources