--IF @month IS NOT NULL AND @day IS NOT NULL SET @start_date = DATEFROMPARTS(@year, @month, @day); --IF @holiday LIKE N'Íîâ%' SET @start_date = dbo.GetNewYearHolidaysStartDate(@year); --IF @holiday ...
declare @IsClusteredInstance varchar(50) = (SELECT CASE SERVERPROPERTY ('IsClustered') WHEN 1 THEN 'Clustered Instance' WHEN 0 THEN 'Non Clustered instance' ELSE 'null' END) declare ...