DECLARE @CurrentDay AS INT = 24;

BEGIN TRY
    SELECT @CurrentDay = DAY(CURRENT_TIMESTAMP)
    PRINT 'Today is the 24th day of the month';
END TRY
BEGIN CATCH
    PRINT 'Today is day number ' + DAY(CURRENT_TIMESTAMP) + ' of the month';
END CATCH

IF @CurrentDay = DAY(CURRENT_TIMESTAMP)
    PRINT 'Today is the 24th day of the month'

SET NOCOUNT ON;
DECLARE @pos TABLE (sale_id varchar(4), product_id int)
DECLARE @err varchar(200) 

BEGIN TRY
	INSERT INTO @pos VALUES ('ccc', 'a')
END TRY
BEGIN CATCH 
	-- update the log file
	SET @err=ERROR_MESSAGE()

	IF ERROR_NUMBER() = 245
		SET @err = @err+'(Still getting bad data from Joe''s ETL)'

	PRINT @err
END CATCH