stored procedure and cursor - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

stored procedure and cursor

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-16 : 10:06:50

Udayakumar writes "Is it possible to call a stored procedure while opening a cursor and handle the resultset, instead of a SQL query ?"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-04-16 : 10:38:46

If you mean this:

DECLARE curs CURSOR FOR EXECUTE storedProcedure

The answer is no.

Why are you using a cursor anyway?

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-04-16 : 10:49:13

assuming you have a decent answer to Rob's Question, an alternative iterative method would be ....


create table #myTempTable (
    myIdent int identity(1,1),
    <column list to match recordset>
)
insert #myTempTable
exec myStoredProcedure

... and then iterate through #myTempTable using the identity and a counter.

<O>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources