[thelist] Stored procedure

[Stevenson Ngila]

Am using coldfusion. But i always prefer leaving the db processing to DB
instead of using coldusion. But seems like there is no way out!

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Ken Schaefer
Sent: 28 January 2003 09:06
To: thelist at lists.evolt.org
Subject: Re: [thelist] Stored procedure


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!

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

--
* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !