Delimited String to Multiple Records In Stored Proc.

[Guest_imported]

Hi all I hope someone can help me.

I have a stored procedure that inserts data into multiple tables. I am wanting to parse a comma delimited string and insert new records for each element. i.e

@year1content = french,german,maths,ecnomics...
(from textarea form field)
@CourseID = @@IDENTITY (from autonumber in main table)

---------------------------------------------------------
SET @CourseID = @@IDENTITY

--insert into year1 Table

INSERT INTO Year1 (CourseID, Content)

VALUES (@CourseID, @year1content) -- I need a loop here?

Return

-------------------------------------
To give me:

Year1
-------------------
ID Content
------------------
2 french
2 german
2 maths
2 economics

Thanks in Advance.

 

[tlbroadbent]

See thread183-95590 for the answer. Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost