>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