[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