[thelist] Stored procedure

Ken Schaefer ken at adOpenStatic.com
Tue Jan 28 00:06:01 CST 2003


Do you have to do this in a sproc? What's your frontend?

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Stevenson Ngila" <Stevenson at epr.footman-walker.com>
Subject: [thelist] Stored procedure


: I have two strings i.e. string1 = "peter,john,steve" and string2=
: "mary,jane,janet".
:
: (1)i want to loop through string1 and string2 and get "peter" from string1
: and "mary" from string2 and insert both name in to a table.
: (2) I want to repeat the above procedure and get "john" and "jane" and
: insert them in to a table.
:
: Can someone please assist me with the stored procedure to do these in SQL
: server 2000!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~




More information about the thelist mailing list