>Perhaps manual was a poor word choice. I was just courious if the method you used had an advantage over the cursor. BTW, your code worked fine.


Rollin,

I find T-SQL cursor cumbersome, inflexible and slow. A table variable with identity column on other hand allows almost the same flexibility as a VFP cursor. You can loop through it in any direction, use it in subsequent queries, update, if neccesary, e.t.c