Thanks for the help! I see the error of my ways!!

I made things difficult for myself by copying an SP I wrote at work. That SP does not do a set after the update statement.

I get it now, the @@ROWCOUNT is getting set to 1 by my Set @CMP line!

Lesson learned!!

Thanks!