Just realized there is a potential problem with the scalar function listed above. The declaration for @LocalResultBit is incorrect in my post. It currently reads:

DECLARE @LocalResultBit varchar(400)

but it...

I came up with the following approach to allow me to launch a "batch" process when I know it needs to be done as opposed to waiting for a scheduled...