SQL Server - Group Concat on Temp Table (SQL2000)

Asked By Brave Cobr

14-Jul-08 08:23 AM

Hi,

I'm having a problem with a group concatenation on a temporary table in a
stored procedure.
I've been looking at
http://omnibuzz-sql.blogspot.com/2006/06/concatenate-values-in-column-in-sql.html
which provides me with a perfect solution for SQL2005 where I can do the
concat in 1 single statement. However, on SQL2000, a UDF is suggested to get
the same output.  The problem is that I need to do the concatentation on a
temporary table. UDF's don't alllow that.

How can I do a session safe (!) group concatenation, as described in the
above link, on a temporary table in a stored procedure on SQL2000.

14-Jul-08 08:29 AM

Brave Cobra
Can you show sample data and an expected result?
Workaround  is to create a peremanent table and just before inserting a new
data set truncate the old data

14-Jul-08 08:30 AM

Have you considered using a cursor in your stored procedure?

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

14-Jul-08 08:31 AM

See: http://www.projectdmx.com/tsql/rowconcatenate.aspx

--
Razvan Socol
SQL Server MVP

14-Jul-08 08:35 AM

Thanks for your reply.
I thought so as well, but that wouldn't be session safe. When 2 users
call the stored procedure at the same (or nearly the same) time, that
would cause a problem of incorrect data. Locking the table would solve
this either. I really need the 'temp' session safe functionality of the
table. Making it permanent shares it among the users. Correct me if I'm
wrong here!

Brave Cobra