Posted by Jason Kester on 06/22/06 11:47

Stu wrote:
> First, try to rewrite your app so you don't use cursors.

Second, Seriously. Try to rewrite your app so you don't use cursors.

You might also consider dropping the guts of your stored procedure into
a User Defined Function that returns a table. Then you can use that
UDF for both the Stored Procedure and your sketchy thing that uses
Cursors.

Good luck!

Jason Kester
Expat Software Consulting Services
http://www.expatsoftware.com/

---
Get your own Travel Blog, with itinerary maps and photos!
http://www.blogabond.com/

• Next in forum: Re: Help with SQL Statement to find first and last populated field in string of fields
• Prev in forum: Re: SQL 2005: creating "correct" and "incorrect" versions of a database
• Thread view: Re: Creating Cursor from Stored Procedure

[Reply to this message]