>Thanks, Mike
>But, actually I think that will only give me a @@rowcount = 1.
That's correct. @@ROWCOUNT will be set to 1 but the value in the result will be the number of rows that match the constraint:
SELECT * FROM Authors
Generates 23 rows so @@ROWCOUNT will be 23 and I'll get a result set containing the 23 rows.
SELECT COUNT(*) FROM Authors
Generates 1 rows so @@ROWCOUNT will be one and I'll get a result set containing 1 rows and 1 column whose value will be 23.
I'm having a hard time visualizing what the stored procedure does. Are you trying to determine the number of row that the query will affect?
-Mike