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 2000 Forums
 SQL Server Development (2000)
 Splitting a comma separated TEXT param into a temp table

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-11-07 : 09:24:09
Steve writes "Hi,

Just read the article on http://www.sqlteam.com/item.asp?ItemID=11499.

I need this exact functionality but for the input param to be of TEXT so it can be more than the 8000 varchar limit.

I'm sure this a probably a question you get asked all the time but i cant find an answer anywhere on the site.

Any ideas appreciated.

Cheers.
Steve."

burbakei
Yak Posting Veteran

80 Posts

Posted - 2002-11-15 : 22:32:21
you can create a table with an id column and a texted type column.
insert an id and the CSV-string to the table and pass the id to the CSV-function.

Go to Top of Page
   

- Advertisement -