Posted by Stu on 06/20/06 14:15

First, try to rewrite your app so you don't use cursors.

Second, if you must use a cursor, you can create a temp table to hold
the output of your stored procedure, and then build a cursor from that;
e.g.:

CREATE TABLE #splat (columnlist)

INSERT INTO #splat
exec myproc

DROP TABLE #splat

Stu

Lucky wrote:
> Hi guys!
> i want to create one cursor in the t-sql. the problem is i want to use
> stored procedure instead of select command in cursor.
>
> can anyone tell me how can i use stored procedure's o/p to create
> cursor?
>
> i'm using sql 2000 and .net 2.0
>
> thanks,
>
> Lucky

• Next in forum: SQLDMO - Getting 'Local' Server name
• Prev in forum: Creating Cursor from Stored Procedure
• Thread view: Re: Creating Cursor from Stored Procedure

[Reply to this message]