---- drop the recursion into a static table

if object_id('dbo._numbers') is null --- drop table dbo._numbers

...

-- f.e.: to split the comma delimited string into rows without using LOOP, CTE, XML.

declare @p nvarchar(max) = '', @start datetime

select @p += name + ',' from master.sys.sysobjects

select items...

fine, but correct is 'Careful with '

(no rtrim and lower used)

you can use char/patindex as IN operator:

where birthday is not NULL and charindex(cast(datepart(month, birthday) as varchar(8)) + ',', '1,3,4,5,7,8,') > 0

-- Execute batch in the old DB

-- Execute result in new DB

-- Script permissions on all tables

-- Author: Th. Fuchs, IMC GmbH Chemnitz

declare @object int,  @hresult int, @property varchar(255), @return...

-- or (not for millseconds)

if object_id('dbo.udf_IsShiftValid') is null

  execute('create function dbo.udf_IsShiftValid() returns integer as begin return 12 end')

go

alter function dbo.udf_IsShiftValid

        (@StartTime datetime

        , @EndTime datetime

        , @DayTime datetime)

RETURNS integer

AS...