Re: Question regarding SP

From: David Gugick (davidg-nospam_at_imceda.com)
Date: 01/25/05 

Date: Mon, 24 Jan 2005 20:04:16 -0500

Patrick wrote:
> 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
>

Those are two different things. Do you want to use the cursor from
within the procedure? if so, see DECLARE CURSOR in the help file.

Do you want to catch the results of one procedure in another? You'll
have to use a temp table (or a real table) to store the results. 

-- 
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)
Loading