I guess you can use @@rowcount, thanks to this script.

The NOT IN can be replaced by a left outer join, which could be a little faster.

BEGIN

Declare @AnyMgtId Int -- a...