I had a look at the link provided and got a clue.

DECLARE @SlowLimit INT, @MediumLimit INT, @ExpressLimit INT, @DevLimit INT

    SELECT
         @SlowLimit = SUM(CASE WHEN processthreadtype =...

Thanks for the reply. The procedure has too much code to post so a few notes about what it does.

The procedure is the main part of an automation...