I am using a cursor in code to to perform a loop. This cursor gets updated within the loop when certain conditions are met. This is all good.

What I need to do after the loop is SELECT all the records from the cursor that are not within another table.

Does SQL Server 7 allow a SELECT from a cursor.

My syntax is:

SELECT * FROM cursorname
WHERE fieldname NOT IN (SELECT otherfieldname FROM table)