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)
 Loop

Author  Topic 

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2007-03-28 : 14:06:48
Hello,

I am passing an NVarChar(MAX) parameter to a stored procedure.

This parameter contains tags separated by commas:
Tag1,Tag2,This is Tag 3,Just a Phrase, Last Tag

I need to create one record for each tag in table TAGS.

How can I do this?

Thanks,
Miguel

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-28 : 14:29:43
Use function fnParseList found here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76033


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -