Re: Question regarding SP

From: Patrick (kingofusa_at_juno.com)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 16:13:52 -0600

I Want to use cursor with in the stored procedure itself.

My main problem is how can I catch the result returned by one procedure in
another procedure.

Marmik

"David Gugick" <davidg-nospam@imceda.com> wrote in message
news:OmXyc$lAFHA.3664@TK2MSFTNGP14.phx.gbl...
> Patrick wrote:
>> Hi guys
>>
>> I have written one stored procedure. At the end it returns the set of
>> rows. I want to define cursor on the result which is sent by stored
>> procedure. How can i do that ?
>>
>> Thanks
>
> How do you mean? You want to use a cursor from the application? Or are you
> saying you want to use the results from one stored procedure in another
> stored procedure? Or are you saying you want to define a cursor on the
> results from within the procedure so you can perform row-by-row
> processing? Or are you saying something else altogether?
>
> Please provide some details about what you are doing. Cursors on SQL
> Server are very slow and there may be other set-based solutions you can
> use.
>
>
> --
> David Gugick
> Imceda Software
> www.imceda.com

Relevant Pages

  • Re: noise words, @@ERROR, and stop and resume indexing
    ... these words at the beginning before sending them to the cursor. ... Looking for a FAQ on Indexing Services/SQL FTS ... >>Create table Noise ... >>> 1) check noise words inside stored procedure ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Error adding command properties for stored procedure call
    ... I see you are using the SQL Native Client for SQL Server ... A server cursor is not allowed on a remote stored procedure or stored ... The stored procedure called is a test one that simply SELECTs the name field ... int InitializeAndConnect; ...
    (microsoft.public.data.oledb)
  • Re: SQL stored procedure not working.
    ... If I do not use that, how can I get the total record count? ... >> I create a stored procedure and a asp page. ... Even if you could specify the cursor type there, ... > interested in the RETURN value, you do not need to use a Command object. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Error adding command properties for stored procedure call
    ... Microsoft OLE DB Provider for SQL Server ... properties to the command the execute call attempts to create a cursor. ... A server cursor is not allowed on a remote stored procedure or stored ...
    (microsoft.public.data.oledb)
  • Re: Stored Procedure
    ... "David Gugick" wrote in message ... > Vince wrote: ... >> a) I can manage transferring this to a Stored Procedure but how do I ... > Put the results in a temp table and use a cursor to loop through the ...
    (microsoft.public.sqlserver.server)