Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Cursorless Cursor

By nagdimunovd,

Here is as sample of implementing cursor.
In some cases my tests showed that this approach performs better than native cursors in SQL Server.
All you have to do is move the dataset into a temp table with a new Identity column and then use a simple loop to extract the data as you would do normally in a cursor.
The major downside of this approach is using it with a large table.
There are couple of ways to create a temp table, you can do it with SELECT INTO, INSERT INTO, Table variable in SQL 2000.
Again each one of theese methods has it's own disadvantages based on the task, with Insert into table has to be created before the data is moved.
Bellow is an example of SELECT INTO implementation

Total article views: 1859 | Views in the last 30 days: 4
Related Articles




cursor problem




Cursor Examples Wanted



How do cursor work?


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones