The @@CURSOR_ROWS can return a negative number for a static cursor under some circumstances. See @@CURSOR_ROWS in BOL for details.
A usual cursor loop has following structure
FETCH NEXT ...
WHILE @@FETCH_STATUS = 0
BEGIN
...
FETCH NEXT ...
END
Anyway, I don't see from your code why do you need a cursor in the first place.
>I figured it out, had to set cursor as static.
>
>
>Using sql 2000
>
>I'm trying to do a query I'm working in QA. When I get set the @tiDocs variable to @@Cursor_rows, it return -1. If I just run the query by itself, I get 148 records. What am I missing?
>
<snip>
--sb--