IF EXISTS (SELECT * FROM dbo.SysObjects WHERE id = object_id(N'dbo.AUDIT_ins_ProductPrice') AND OBJECTPROPERTY(id, N'IsTrigger') = 1) DROP TRIGGER dbo.AUDIT_ins_ProductPrice 
GO
CREATE TRIGGER [dbo].[AUDIT_ins_ProductPrice]
ON [dbo].[ProductPrice] FOR INSERT NOT FOR REPLICATION AS
BEGIN
	  
	DECLARE @FiscalSweden INT
	SELECT @FiscalSweden = COUNT(*) 
	FROM dbo.HotelSetup h WITH (NOLOCK) 
	INNER JOIN HotelSetupValueXTab vx WITH (NOLOCK) ON vx.HotelSetupNumber = h.HotelSetupNumber AND UPPER(h.SearchKey) = UPPER('FiscalPrinterSweden')
	INNER JOIN HotelSetupValue v WITH (NOLOCK) ON vx.fk_ValueNumber = v.Pk_ValueNumber
	WHERE v.KeyValue = '1'
	IF ISNULL(@FiscalSweden, 0) = 0
		RETURN
	

	DECLARE 
		@IDENTITY_SAVE				varchar(50),
		@AUDIT_LOG_TRANSACTION_ID		Int,
		@PRIM_KEY				nvarchar(4000),
		@ROWS_COUNT				int,
		@FK_UserIdNumber INT,
		@FK_CashBox INT,
		@ProgramPart SMALLINT,
		@TerminalName VARCHAR(50),
		@SystemDateStr VARCHAR(8),
		@SystemDateTime DATETIME
 
	SET NOCOUNT ON

	Select @ROWS_COUNT=count(*) from inserted
	Set @IDENTITY_SAVE = CAST(IsNull(@@IDENTITY,1) AS varchar(50))

    SELECT TOP 1 @FK_UserIdNumber = FK_UserIdNumber,
	@FK_CashBox = FK_CashBox,
	@ProgramPart = ProgramPart,
	@TerminalName = TerminalName
	FROM PersonnelLogInfo WITH (NOLOCK)
	WHERE spid = @@spid
	ORDER BY CreateDate DESC
	
	IF ISNULL(@FK_UserIdNumber, 0) = 0
	  SET @FK_UserIdNumber = 1
	IF ISNULL(@FK_CashBox, -1) <= 0
	  SET @FK_CashBox = -1
	IF ISNULL(@ProgramPart, -1) <= 0
	  SET @ProgramPart = 14 -- ppUnknown from SystemAll
	IF ISNULL(@TerminalName, '') = ''
	  SET @TerminalName = 'Unknown'	 

    SELECT @SystemDateStr = SystemDate FROM System WITH (NOLOCK) WHERE Number = 1
    SET @SystemDateTime = CONVERT(DATETIME, @SystemDateStr + ' ' + CONVERT(CHAR(8), CURRENT_TIMESTAMP, 108))
	
	INSERT INTO dbo.AUDIT_LOG_TRANSACTIONS
	(
		TABLE_NAME,
		TABLE_SCHEMA,
		AUDIT_ACTION_ID,
		HOST_NAME,
		APP_NAME,
		MODIFIED_BY,
		MODIFIED_DATE,
		AFFECTED_ROWS,
		FK_UserIdNumber,
		FK_CashBox,
		ProgramPart,
		TerminalName,
		RealDateTime
	)
	values(
		'ProductPrice',
		'dbo',
		2,	--	ACTION ID For INSERT
		CASE 
		  WHEN LEN(HOST_NAME()) < 1 THEN ' '
		  ELSE HOST_NAME()
		END,
		CASE 
		  WHEN LEN(APP_NAME()) < 1 THEN ' '
		  ELSE APP_NAME()
		END,
		SUSER_SNAME(),
		@SystemDateTime,
		@ROWS_COUNT,
		@FK_UserIdNumber,
		@FK_CashBox,
		@ProgramPart,
		@TerminalName,
		GETDATE()
	)
	
	Set @AUDIT_LOG_TRANSACTION_ID = SCOPE_IDENTITY()
	

	
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultPrice1',
		CONVERT(nvarchar(4000), NEW.[AdultPrice1], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultPrice1], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultPrice2',
		CONVERT(nvarchar(4000), NEW.[AdultPrice2], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultPrice2], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultPrice3',
		CONVERT(nvarchar(4000), NEW.[AdultPrice3], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultPrice3], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultPrice4',
		CONVERT(nvarchar(4000), NEW.[AdultPrice4], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultPrice4], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultPrice5',
		CONVERT(nvarchar(4000), NEW.[AdultPrice5], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultPrice5], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultPrice6',
		CONVERT(nvarchar(4000), NEW.[AdultPrice6], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultPrice6], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultPrice7',
		CONVERT(nvarchar(4000), NEW.[AdultPrice7], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultPrice7], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultPrice8',
		CONVERT(nvarchar(4000), NEW.[AdultPrice8], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultPrice8], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultPrice9',
		CONVERT(nvarchar(4000), NEW.[AdultPrice9], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultPrice9], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1Price1',
		CONVERT(nvarchar(4000), NEW.[Children1Price1], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1Price1], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1Price2',
		CONVERT(nvarchar(4000), NEW.[Children1Price2], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1Price2], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1Price3',
		CONVERT(nvarchar(4000), NEW.[Children1Price3], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1Price3], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1Price4',
		CONVERT(nvarchar(4000), NEW.[Children1Price4], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1Price4], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1Price5',
		CONVERT(nvarchar(4000), NEW.[Children1Price5], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1Price5], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1Price6',
		CONVERT(nvarchar(4000), NEW.[Children1Price6], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1Price6], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1Price7',
		CONVERT(nvarchar(4000), NEW.[Children1Price7], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1Price7], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1Price8',
		CONVERT(nvarchar(4000), NEW.[Children1Price8], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1Price8], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1Price9',
		CONVERT(nvarchar(4000), NEW.[Children1Price9], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1Price9], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2Price1',
		CONVERT(nvarchar(4000), NEW.[Children2Price1], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2Price1], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2Price2',
		CONVERT(nvarchar(4000), NEW.[Children2Price2], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2Price2], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2Price3',
		CONVERT(nvarchar(4000), NEW.[Children2Price3], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2Price3], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2Price4',
		CONVERT(nvarchar(4000), NEW.[Children2Price4], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2Price4], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2Price5',
		CONVERT(nvarchar(4000), NEW.[Children2Price5], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2Price5], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2Price6',
		CONVERT(nvarchar(4000), NEW.[Children2Price6], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2Price6], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2Price7',
		CONVERT(nvarchar(4000), NEW.[Children2Price7], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2Price7], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2Price8',
		CONVERT(nvarchar(4000), NEW.[Children2Price8], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2Price8], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2Price9',
		CONVERT(nvarchar(4000), NEW.[Children2Price9], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2Price9], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultArrivalAddon',
		CONVERT(nvarchar(4000), NEW.[AdultArrivalAddon], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultArrivalAddon], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultStayAddon',
		CONVERT(nvarchar(4000), NEW.[AdultStayAddon], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultStayAddon], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultDepartureAddon',
		CONVERT(nvarchar(4000), NEW.[AdultDepartureAddon], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultDepartureAddon], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1ArrivalAddon',
		CONVERT(nvarchar(4000), NEW.[Children1ArrivalAddon], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1ArrivalAddon], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1StayAddon',
		CONVERT(nvarchar(4000), NEW.[Children1StayAddon], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1StayAddon], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1DepartureAddon',
		CONVERT(nvarchar(4000), NEW.[Children1DepartureAddon], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1DepartureAddon], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2ArrivalAddon',
		CONVERT(nvarchar(4000), NEW.[Children2ArrivalAddon], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2ArrivalAddon], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2StayAddon',
		CONVERT(nvarchar(4000), NEW.[Children2StayAddon], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2StayAddon], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2DepartureAddon',
		CONVERT(nvarchar(4000), NEW.[Children2DepartureAddon], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2DepartureAddon], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'ArrivalPacketNumber',
		CONVERT(nvarchar(4000), NEW.[ArrivalPacketNumber], 0),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[ArrivalPacketNumber], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'StayPacketNumber',
		CONVERT(nvarchar(4000), NEW.[StayPacketNumber], 0),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[StayPacketNumber], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'DeparturePacketNumber',
		CONVERT(nvarchar(4000), NEW.[DeparturePacketNumber], 0),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[DeparturePacketNumber], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultArrivalAddon2',
		CONVERT(nvarchar(4000), NEW.[AdultArrivalAddon2], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultArrivalAddon2], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultArrivalAddon3',
		CONVERT(nvarchar(4000), NEW.[AdultArrivalAddon3], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultArrivalAddon3], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultArrivalAddon4',
		CONVERT(nvarchar(4000), NEW.[AdultArrivalAddon4], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultArrivalAddon4], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultArrivalAddon5',
		CONVERT(nvarchar(4000), NEW.[AdultArrivalAddon5], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultArrivalAddon5], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultArrivalAddon6',
		CONVERT(nvarchar(4000), NEW.[AdultArrivalAddon6], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultArrivalAddon6], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultArrivalAddon7',
		CONVERT(nvarchar(4000), NEW.[AdultArrivalAddon7], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultArrivalAddon7], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultArrivalAddon8',
		CONVERT(nvarchar(4000), NEW.[AdultArrivalAddon8], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultArrivalAddon8], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultArrivalAddon9',
		CONVERT(nvarchar(4000), NEW.[AdultArrivalAddon9], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultArrivalAddon9], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultStayAddon2',
		CONVERT(nvarchar(4000), NEW.[AdultStayAddon2], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultStayAddon2], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultStayAddon3',
		CONVERT(nvarchar(4000), NEW.[AdultStayAddon3], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultStayAddon3], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultStayAddon4',
		CONVERT(nvarchar(4000), NEW.[AdultStayAddon4], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultStayAddon4], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultStayAddon5',
		CONVERT(nvarchar(4000), NEW.[AdultStayAddon5], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultStayAddon5], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultStayAddon6',
		CONVERT(nvarchar(4000), NEW.[AdultStayAddon6], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultStayAddon6], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultStayAddon7',
		CONVERT(nvarchar(4000), NEW.[AdultStayAddon7], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultStayAddon7], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultStayAddon8',
		CONVERT(nvarchar(4000), NEW.[AdultStayAddon8], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultStayAddon8], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultStayAddon9',
		CONVERT(nvarchar(4000), NEW.[AdultStayAddon9], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultStayAddon9], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultDepartureAddon2',
		CONVERT(nvarchar(4000), NEW.[AdultDepartureAddon2], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultDepartureAddon2], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultDepartureAddon3',
		CONVERT(nvarchar(4000), NEW.[AdultDepartureAddon3], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultDepartureAddon3], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultDepartureAddon4',
		CONVERT(nvarchar(4000), NEW.[AdultDepartureAddon4], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultDepartureAddon4], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultDepartureAddon5',
		CONVERT(nvarchar(4000), NEW.[AdultDepartureAddon5], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultDepartureAddon5], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultDepartureAddon6',
		CONVERT(nvarchar(4000), NEW.[AdultDepartureAddon6], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultDepartureAddon6], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultDepartureAddon7',
		CONVERT(nvarchar(4000), NEW.[AdultDepartureAddon7], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultDepartureAddon7], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultDepartureAddon8',
		CONVERT(nvarchar(4000), NEW.[AdultDepartureAddon8], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultDepartureAddon8], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'AdultDepartureAddon9',
		CONVERT(nvarchar(4000), NEW.[AdultDepartureAddon9], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[AdultDepartureAddon9], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1ArrivalAddon2',
		CONVERT(nvarchar(4000), NEW.[Children1ArrivalAddon2], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1ArrivalAddon2], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1ArrivalAddon3',
		CONVERT(nvarchar(4000), NEW.[Children1ArrivalAddon3], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1ArrivalAddon3], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1ArrivalAddon4',
		CONVERT(nvarchar(4000), NEW.[Children1ArrivalAddon4], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1ArrivalAddon4], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1ArrivalAddon5',
		CONVERT(nvarchar(4000), NEW.[Children1ArrivalAddon5], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1ArrivalAddon5], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1ArrivalAddon6',
		CONVERT(nvarchar(4000), NEW.[Children1ArrivalAddon6], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1ArrivalAddon6], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1ArrivalAddon7',
		CONVERT(nvarchar(4000), NEW.[Children1ArrivalAddon7], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1ArrivalAddon7], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1ArrivalAddon8',
		CONVERT(nvarchar(4000), NEW.[Children1ArrivalAddon8], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1ArrivalAddon8], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1ArrivalAddon9',
		CONVERT(nvarchar(4000), NEW.[Children1ArrivalAddon9], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1ArrivalAddon9], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1StayAddon2',
		CONVERT(nvarchar(4000), NEW.[Children1StayAddon2], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1StayAddon2], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1StayAddon3',
		CONVERT(nvarchar(4000), NEW.[Children1StayAddon3], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1StayAddon3], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1StayAddon4',
		CONVERT(nvarchar(4000), NEW.[Children1StayAddon4], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1StayAddon4], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1StayAddon5',
		CONVERT(nvarchar(4000), NEW.[Children1StayAddon5], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1StayAddon5], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1StayAddon6',
		CONVERT(nvarchar(4000), NEW.[Children1StayAddon6], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1StayAddon6], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1StayAddon7',
		CONVERT(nvarchar(4000), NEW.[Children1StayAddon7], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1StayAddon7], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1StayAddon8',
		CONVERT(nvarchar(4000), NEW.[Children1StayAddon8], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1StayAddon8], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1StayAddon9',
		CONVERT(nvarchar(4000), NEW.[Children1StayAddon9], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1StayAddon9], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1DepartureAddon2',
		CONVERT(nvarchar(4000), NEW.[Children1DepartureAddon2], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1DepartureAddon2], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1DepartureAddon3',
		CONVERT(nvarchar(4000), NEW.[Children1DepartureAddon3], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1DepartureAddon3], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1DepartureAddon4',
		CONVERT(nvarchar(4000), NEW.[Children1DepartureAddon4], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1DepartureAddon4], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1DepartureAddon5',
		CONVERT(nvarchar(4000), NEW.[Children1DepartureAddon5], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1DepartureAddon5], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1DepartureAddon6',
		CONVERT(nvarchar(4000), NEW.[Children1DepartureAddon6], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1DepartureAddon6], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1DepartureAddon7',
		CONVERT(nvarchar(4000), NEW.[Children1DepartureAddon7], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1DepartureAddon7], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1DepartureAddon8',
		CONVERT(nvarchar(4000), NEW.[Children1DepartureAddon8], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1DepartureAddon8], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children1DepartureAddon9',
		CONVERT(nvarchar(4000), NEW.[Children1DepartureAddon9], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children1DepartureAddon9], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2ArrivalAddon2',
		CONVERT(nvarchar(4000), NEW.[Children2ArrivalAddon2], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2ArrivalAddon2], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2ArrivalAddon3',
		CONVERT(nvarchar(4000), NEW.[Children2ArrivalAddon3], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2ArrivalAddon3], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2ArrivalAddon4',
		CONVERT(nvarchar(4000), NEW.[Children2ArrivalAddon4], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2ArrivalAddon4], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2ArrivalAddon5',
		CONVERT(nvarchar(4000), NEW.[Children2ArrivalAddon5], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2ArrivalAddon5], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2ArrivalAddon6',
		CONVERT(nvarchar(4000), NEW.[Children2ArrivalAddon6], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2ArrivalAddon6], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2ArrivalAddon7',
		CONVERT(nvarchar(4000), NEW.[Children2ArrivalAddon7], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2ArrivalAddon7], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2ArrivalAddon8',
		CONVERT(nvarchar(4000), NEW.[Children2ArrivalAddon8], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2ArrivalAddon8], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2ArrivalAddon9',
		CONVERT(nvarchar(4000), NEW.[Children2ArrivalAddon9], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2ArrivalAddon9], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2StayAddon2',
		CONVERT(nvarchar(4000), NEW.[Children2StayAddon2], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2StayAddon2], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2StayAddon3',
		CONVERT(nvarchar(4000), NEW.[Children2StayAddon3], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2StayAddon3], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2StayAddon4',
		CONVERT(nvarchar(4000), NEW.[Children2StayAddon4], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2StayAddon4], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2StayAddon5',
		CONVERT(nvarchar(4000), NEW.[Children2StayAddon5], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2StayAddon5], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2StayAddon6',
		CONVERT(nvarchar(4000), NEW.[Children2StayAddon6], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2StayAddon6], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2StayAddon7',
		CONVERT(nvarchar(4000), NEW.[Children2StayAddon7], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2StayAddon7], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2StayAddon8',
		CONVERT(nvarchar(4000), NEW.[Children2StayAddon8], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2StayAddon8], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2StayAddon9',
		CONVERT(nvarchar(4000), NEW.[Children2StayAddon9], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2StayAddon9], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2DepartureAddon2',
		CONVERT(nvarchar(4000), NEW.[Children2DepartureAddon2], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2DepartureAddon2], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2DepartureAddon3',
		CONVERT(nvarchar(4000), NEW.[Children2DepartureAddon3], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2DepartureAddon3], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2DepartureAddon4',
		CONVERT(nvarchar(4000), NEW.[Children2DepartureAddon4], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2DepartureAddon4], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2DepartureAddon5',
		CONVERT(nvarchar(4000), NEW.[Children2DepartureAddon5], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2DepartureAddon5], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2DepartureAddon6',
		CONVERT(nvarchar(4000), NEW.[Children2DepartureAddon6], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2DepartureAddon6], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2DepartureAddon7',
		CONVERT(nvarchar(4000), NEW.[Children2DepartureAddon7], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2DepartureAddon7], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2DepartureAddon8',
		CONVERT(nvarchar(4000), NEW.[Children2DepartureAddon8], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2DepartureAddon8], 0) <> 0
	
    
	INSERT INTO dbo.AUDIT_LOG_DATA
	(
		AUDIT_LOG_TRANSACTION_ID,
		PRIMARY_KEY_DATA,
		COL_NAME,
		NEW_VALUE_LONG,
		DATA_TYPE
		, KEY1, KEY2, KEY3
	)
	SELECT
		@AUDIT_LOG_TRANSACTION_ID,
		convert(nvarchar(1500), IsNull('[ProductNumber]='+CONVERT(nvarchar(4000), NEW.[ProductNumber], 0), '[ProductNumber] Is Null') + ' AND ' + IsNull('[DateStamp]=N'''+replace(CONVERT(nvarchar(4000), NEW.[DateStamp], 0), '''', '''''')+'''', '[DateStamp] Is Null') + ' AND ' + IsNull('[RoomtypeNumber]='+CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0), '[RoomtypeNumber] Is Null')),
		'Children2DepartureAddon9',
		CONVERT(nvarchar(4000), NEW.[Children2DepartureAddon9], 2),
		'A'
		, CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[ProductNumber], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[DateStamp], 0)), CONVERT(nvarchar(500), CONVERT(nvarchar(4000), NEW.[RoomtypeNumber], 0))
	FROM inserted NEW
	
	  WHERE ISNULL(NEW.[Children2DepartureAddon9], 0) <> 0
	
    
	
	-- Lookup 
	

	-- Restore @@IDENTITY Value 
    DECLARE @maxprec AS varchar(2)
    SET @maxprec=CAST(@@MAX_PRECISION as varchar(2))
    EXEC('SELECT IDENTITY(decimal('+@maxprec+',0),'+@IDENTITY_SAVE+',1) id INTO #tmp')	
End
