[thelist] Stored procedure

Stevenson Ngila Stevenson at epr.footman-walker.com
Tue Jan 28 00:02:01 CST 2003


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