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
 Concatenation

Author  Topic 

Mark_coffee
Starting Member

2 Posts

Posted - 2009-05-08 : 00:07:43
Hullo everybody, I am new with SQL. I need to know how to concatenate all the data in one column and put it in a variable. Thanks.

"I thoroughly disapprove of duels. If a man should challenge me, I would take him kindly and forgivingly by the hand and lead him to a quiet place and kill him." -Mark Twain

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-05-08 : 00:20:20
see
http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/rowset-string-concatenation-which-method-is-best.aspx
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

Mark_coffee
Starting Member

2 Posts

Posted - 2009-05-08 : 12:05:52
Thanks!

"I thoroughly disapprove of duels. If a man should challenge me, I would take him kindly and forgivingly by the hand and lead him to a quiet place and kill him." -Mark Twain
Go to Top of Page
   

- Advertisement -