If I understand what you're trying to do correctly, try this:

while(@min_AlertProcedure IS NOT NULL AND @min_AlertProcedure <= @max_AlertProcedure)

begin

begin try

...

Thanks for the reply.

Here's the column I'm selecting in the view:

cast(substring(table_name, charindex('_', table_name) + 1, 100) as int) as Period

I'm casting this as an int and it runs...

Thanks for the tips. I grabbed a copy of WhoIsActive, really nice stuff.

I have started to transition to use the system views and functions, but everyone I work with...

Great, thanks for the clarification.