In Germany we also know that saying. Thanks 😉

What is the advantage to just use

SELECT msg = CASE t.i

WHEN 1 THEN 'ONE'

WHEN 2 THEN 'TWO'

WHEN 3 THEN 'THREE'

ELSE CAST(1/0 AS VARCHAR(10))

END

FROM @t t

?

Hello Arun,

thanks for the answer. However, what I meant were the equal names  of the solution description:

Check_async_SQLAgent_jobs_and_alert.sql: Use this script to create another stored procedure which will check and e-mail...

Hello,

just to mention that the last two scripts have the same name in the initial description as well as in the scripts itself (there the description is also the same).