USE [METX]
GO
/****** Object:  Trigger [mt].[ots_cl_calibration_update]    Script Date: 9/24/2024 11:46:37 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [mt].[ots_cl_calibration_update] 
	ON [mt].[Calibration] 
	AFTER UPDATE
	AS

BEGIN TRY

	SET NOCOUNT ON;

	DECLARE @current_user CHAR(60),
	@assetnum CHAR(60),
	@mtag CHAR(80),
	@old_ctag CHAR(80),
	@new_ctag CHAR(80),
	@old_C2301 date,
	@old_C2302 int,
	@old_C2303 date,
	@old_C2304 int,
	@old_C2306 date,
	@old_C2307 nvarchar(20),
	@old_C2308 nvarchar(10),
	@old_C2309 numeric(12,2),
	@old_C2310 numeric(5,1),
	@old_C2311 numeric(6,2),
	@old_C2312 numeric(6,2),
	@old_C2313 nvarchar(15),
	@old_C2314 nvarchar(16),
	@old_C2315 numeric(5,1),
	@old_C2316 date,
	@old_C2317 numeric(5,1),
	@old_C2318 nvarchar(13),
	@old_C2319 nvarchar(1),
	@old_C2320 nvarchar(128),
	@old_C2321 nvarchar(55),
	@old_C2322 nvarchar(1),
	@old_C2323 nvarchar(1),
	@old_C2324 numeric(5,1),
	@old_C2325 nvarchar(1),
	@old_C2326 nvarchar(44),
	@old_C2327 nvarchar(20),
	@old_C2328 numeric(5,1),
	@old_C2329 nvarchar(44),
	@old_C2330 nvarchar(10),
	@old_C2331 nvarchar(1),
	@old_C2332 int,
	@old_C2333 nvarchar(8),
	@old_C2334 nvarchar(8),
	@old_C2335 datetime2(7),
	@old_C2336 nvarchar(16),
	@old_C2337 datetime2(7),
	@old_C2338 nvarchar(16),
	@old_C2339 int,
	@old_C2341 nvarchar(254),
	@old_C2342 date,
	@old_C2343 nvarchar(8),
	@old_C2344 int,
	@old_C2345 int,
	@old_C2346 int,
	@old_C2347 int,
	@old_C2350 int,
	@old_C2351 int,
	@old_C2352 int,
	@old_C2353 int,
	@old_C2354 nvarchar(64),
	@old_C2355 nvarchar(64),
	@old_C2356 nvarchar(64),
	@old_C2357 nvarchar(64),
	@old_C2358 nvarchar(64),
	@old_C2359 nvarchar(512),
	@old_C2360 nvarchar(64),
	@old_C2361 nvarchar(64),
	@old_C2362 int,
	@old_C2363 nvarchar(1),
	@old_C2364 nvarchar(48),
	@old_C2365 nvarchar(80),
	@old_C2366 nvarchar(50),
	@old_C2367 nvarchar(48),
	@old_C2368 nvarchar(48),
	@old_C2369 nvarchar(48),
	@old_C2370 nvarchar(48),
	@old_C2371 date,
	@old_C2372 date,
	@old_C2373 date,
	@old_C2374 date,
	@old_C2375 numeric(12,2),
	@old_C2376 numeric(12,2),
	@old_C2377 numeric(12,2),
	@old_C2378 numeric(12,2),
	@old_C2379 numeric(12,2),
	@old_C2380 date,
	@old_C2381 nvarchar(8),
	@old_C2382 nvarchar(1),
	@old_C2383 int,
	@old_C2384 nvarchar(4000),
	@old_C2385 nvarchar(128),
	@old_C2386 numeric(5,1),
	@old_C2387 numeric(5,1),
	@old_C2388 numeric(9,2),
	@old_C2389 numeric(7,2),
	@old_C2390 numeric(9,2),
	@old_C2391 numeric,
	@old_C2392 numeric,
	@old_C2393 nvarchar(1),
	@old_C2394 nvarchar(1),
	@old_C2395 nvarchar(10),
	@old_C2396 nvarchar(16);

	DECLARE @new_C2301 date,
	@new_C2302 int,
	@new_C2303 date,
	@new_C2304 int,
	@new_C2306 date,
	@new_C2307 nvarchar(20),
	@new_C2308 nvarchar(10),
	@new_C2309 numeric(12,2),
	@new_C2310 numeric(5,1),
	@new_C2311 numeric(6,2),
	@new_C2312 numeric(6,2),
	@new_C2313 nvarchar(15),
	@new_C2314 nvarchar(16),
	@new_C2315 numeric(5,1),
	@new_C2316 date,
	@new_C2317 numeric(5,1),
	@new_C2318 nvarchar(13),
	@new_C2319 nvarchar(1),
	@new_C2320 nvarchar(128),
	@new_C2321 nvarchar(55),
	@new_C2322 nvarchar(1),
	@new_C2323 nvarchar(1),
	@new_C2324 numeric(5,1),
	@new_C2325 nvarchar(1),
	@new_C2326 nvarchar(44),
	@new_C2327 nvarchar(20),
	@new_C2328 numeric(5,1),
	@new_C2329 nvarchar(44),
	@new_C2330 nvarchar(10),
	@new_C2331 nvarchar(1),
	@new_C2332 int,
	@new_C2333 nvarchar(8),
	@new_C2334 nvarchar(8),
	@new_C2335 datetime2(7),
	@new_C2336 nvarchar(16),
	@new_C2337 datetime2(7),
	@new_C2338 nvarchar(16),
	@new_C2339 int,
	@new_C2341 nvarchar(254),
	@new_C2342 date,
	@new_C2343 nvarchar(8),
	@new_C2344 int,
	@new_C2345 int,
	@new_C2346 int,
	@new_C2347 int,
	@new_C2350 int,
	@new_C2351 int,
	@new_C2352 int,
	@new_C2353 int,
	@new_C2354 nvarchar(64),
	@new_C2355 nvarchar(64),
	@new_C2356 nvarchar(64),
	@new_C2357 nvarchar(64),
	@new_C2358 nvarchar(64),
	@new_C2359 nvarchar(512),
	@new_C2360 nvarchar(64),
	@new_C2361 nvarchar(64),
	@new_C2362 int,
	@new_C2363 nvarchar(1),
	@new_C2364 nvarchar(48),
	@new_C2365 nvarchar(80),
	@new_C2366 nvarchar(50),
	@new_C2367 nvarchar(48),
	@new_C2368 nvarchar(48),
	@new_C2369 nvarchar(48),
	@new_C2370 nvarchar(48),
	@new_C2371 date,
	@new_C2372 date,
	@new_C2373 date,
	@new_C2374 date,
	@new_C2375 numeric(12,2),
	@new_C2376 numeric(12,2),
	@new_C2377 numeric(12,2),
	@new_C2378 numeric(12,2),
	@new_C2379 numeric(12,2),
	@new_C2380 date,
	@new_C2381 nvarchar(8),
	@new_C2382 nvarchar(1),
	@new_C2383 int,
	@new_C2384 nvarchar(4000),
	@new_C2385 nvarchar(128),
	@new_C2386 numeric(5,1),
	@new_C2387 numeric(5,1),
	@new_C2388 numeric(9,2),
	@new_C2389 numeric(7,2),
	@new_C2390 numeric(9,2),
	@new_C2391 numeric,
	@new_C2392 numeric,
	@new_C2393 nvarchar(1),
	@new_C2394 nvarchar(1),
	@new_C2395 nvarchar(10),
	@new_C2396 nvarchar(16);

	SELECT @current_user = SUSER_SNAME();

	DECLARE @RowCount INTEGER,
	@I INTEGER;

	SELECT  @RowCount=count(*) FROM deleted;
	IF @RowCount = 0
		RETURN;

	DECLARE @tmp_ots_cl_calibration_update_d TABLE (
		ColumnID INT IDENTITY(1,1),
		[C2301] [date] NOT NULL,
		[C2302] [int] NULL,
		[C2303] [date] NULL,
		[C2304] [int] NULL,
		[C2306] [date] NULL,
		[C2307] [nvarchar](20) NULL,
		[C2308] [nvarchar](10) NULL,
		[C2309] [numeric](12,2) NULL,
		[C2310] [numeric](5,1) NULL,
		[C2311] [numeric](6,2) NULL,
		[C2312] [numeric](6,2) NULL,
		[C2313] [nvarchar](15) NULL,
		[C2314] [nvarchar](16) NULL,
		[C2315] [numeric](5,1) NULL,
		[C2316] [date] NULL,
		[C2317] [numeric](5,1) NULL,
		[C2318] [nvarchar](13) NULL,
		[C2319] [nvarchar](1) NULL,
		[C2320] [nvarchar](128) NULL,
		[C2321] [nvarchar](55) NULL,
		[C2322] [nvarchar](1) NULL,
		[C2323] [nvarchar](1) NULL,
		[C2324] [numeric](5,1) NULL,
		[C2325] [nvarchar](1) NULL,
		[C2326] [nvarchar](44) NULL,
		[C2327] [nvarchar](20) NULL,
		[C2328] [numeric](5,1) NULL,
		[C2329] [nvarchar](44) NULL,
		[C2330] [nvarchar](10) NULL,
		[C2331] [nvarchar](1) NOT NULL,
		[C2332] [int] NULL,
		[C2333] [nvarchar](8) NOT NULL,
		[C2334] [nvarchar](8) NULL,
		[C2335] [datetime2](7) NULL,
		[C2336] [nvarchar](16) NULL,
		[C2337] [datetime2](7) NULL,
		[C2338] [nvarchar](16) NULL,
		[C2339] [int] NULL,
		[C2341] [nvarchar](254) NULL,
		[C2342] [date] NULL,
		[C2343] [nvarchar](8) NULL,
		[C2344] [int] NULL,
		[C2345] [int] NULL,
		[C2346] [int] NULL,
		[C2347] [int] NULL,
		[C2350] [int] NULL,
		[C2351] [int] NULL,
		[C2352] [int] NULL,
		[C2353] [int] NULL,
		[C2354] [nvarchar](64) NULL,
		[C2355] [nvarchar](64) NULL,
		[C2356] [nvarchar](64) NULL,
		[C2357] [nvarchar](64) NULL,
		[C2358] [nvarchar](64) NULL,
		[C2359] [nvarchar](512) NULL,
		[C2360] [nvarchar](64) NULL,
		[C2361] [nvarchar](64) NULL,
		[C2362] [int] NULL,
		[C2363] [nvarchar](1) NULL,
		[C2364] [nvarchar](48) NULL,
		[C2365] [nvarchar](80) NULL,
		[C2366] [nvarchar](50) NULL,
		[C2367] [nvarchar](48) NULL,
		[C2368] [nvarchar](48) NULL,
		[C2369] [nvarchar](48) NULL,
		[C2370] [nvarchar](48) NULL,
		[C2371] [date] NULL,
		[C2372] [date] NULL,
		[C2373] [date] NULL,
		[C2374] [date] NULL,
		[C2375] [numeric](12,2) NULL,
		[C2376] [numeric](12,2) NULL,
		[C2377] [numeric](12,2) NULL,
		[C2378] [numeric](12,2) NULL,
		[C2379] [numeric](12,2) NULL,
		[C2380] [date] NULL,
		[C2381] [nvarchar](8) NULL,
		[C2382] [nvarchar](1) NULL,
		[C2383] [int] NULL,
		[C2384] [nvarchar](4000) NULL,
		[C2385] [nvarchar](128) NULL,
		[C2386] [numeric](5,1) NULL,
		[C2387] [numeric](5,1) NULL,
		[C2388] [numeric](9,2) NULL,
		[C2389] [numeric](7,2) NULL,
		[C2390] [numeric](9,2) NULL,
		[C2391] [numeric](7,2) NULL,
		[C2392] [numeric](2,0) NULL,
		[C2393] [nvarchar](1) NULL,
		[C2394] [nvarchar](1) NULL,
		[C2395] [nvarchar](10) NULL,
		[C2396] [nvarchar](16) NULL,
		[MTAG] [nvarchar](80) NOT NULL,
		[CTAG] [nvarchar](80) NOT NULL
		); 

	INSERT INTO @tmp_ots_cl_calibration_update_d  
		SELECT C2301,
		C2302,
		C2303,
		C2304,
		C2306,
		C2307,
		C2308,
		C2309,
		C2310,
		C2311,
		C2312,
		C2313,
		C2314,
		C2315,
		C2316,
		C2317,
		C2318,
		C2319,
		C2320,
		C2321,
		C2322,
		C2323,
		C2324,
		C2325,
		C2326,
		C2327,
		C2328,
		C2329,
		C2330,
		C2331,
		C2332,
		C2333,
		C2334,
		C2335,
		C2336,
		C2337,
		C2338,
		C2339,
		C2341,
		C2342,
		C2343,
		c2344,
		c2345,
		C2346,
		C2347,
		C2350,
		C2351,
		C2352,
		C2353,
		C2354,
		C2355,
		C2356,
		C2357,
		C2358,
		C2359,
		C2360,
		C2361,
		C2362,
		C2363,
		C2364,
		C2365,
		C2366,
		C2367,
		C2368,
		C2369,
		C2370,
		C2371,
		C2372,
		C2373,
		C2374,
		C2375,
		C2376,
		C2377,
		C2378,
		C2379,
		C2380,
		C2381,
		C2382,
		C2383,
		C2384,
		C2385,
		C2386,
		C2387,
		C2388,
		C2389,
		C2390,
		C2391,
		C2392,
		C2393,
		C2394,
		C2395,
		C2396,
		MTAG,
		CTAG
		FROM deleted;

	DECLARE @tmp_ots_cl_calibration_update_i TABLE (
		ColumnID INT IDENTITY(1,1),
		[C2301] [date] NOT NULL,
		[C2302] [int] NULL,
		[C2303] [date] NULL,
		[C2304] [int] NULL,
		[C2306] [date] NULL,
		[C2307] [nvarchar](20) NULL,
		[C2308] [nvarchar](10) NULL,
		[C2309] [numeric](12,2) NULL,
		[C2310] [numeric](5,1) NULL,
		[C2311] [numeric](6,2) NULL,
		[C2312] [numeric](6,2) NULL,
		[C2313] [nvarchar](15) NULL,
		[C2314] [nvarchar](16) NULL,
		[C2315] [numeric](5,1) NULL,
		[C2316] [date] NULL,
		[C2317] [numeric](5,1) NULL,
		[C2318] [nvarchar](13) NULL,
		[C2319] [nvarchar](1) NULL,
		[C2320] [nvarchar](128) NULL,
		[C2321] [nvarchar](55) NULL,
		[C2322] [nvarchar](1) NULL,
		[C2323] [nvarchar](1) NULL,
		[C2324] [numeric](5,1) NULL,
		[C2325] [nvarchar](1) NULL,
		[C2326] [nvarchar](44) NULL,
		[C2327] [nvarchar](20) NULL,
		[C2328] [numeric](5,1) NULL,
		[C2329] [nvarchar](44) NULL,
		[C2330] [nvarchar](10) NULL,
		[C2331] [nvarchar](1) NOT NULL,
		[C2332] [int] NULL,
		[C2333] [nvarchar](8) NOT NULL,
		[C2334] [nvarchar](8) NULL,
		[C2335] [datetime2](7) NULL,
		[C2336] [nvarchar](16) NULL,
		[C2337] [datetime2](7) NULL,
		[C2338] [nvarchar](16) NULL,
		[C2339] [int] NULL,
		[C2341] [nvarchar](254) NULL,
		[C2342] [date] NULL,
		[C2343] [nvarchar](8) NULL,
		[C2344] [int] NULL,
		[C2345] [int] NULL,
		[C2346] [int] NULL,
		[C2347] [int] NULL,
		[C2350] [int] NULL,
		[C2351] [int] NULL,
		[C2352] [int] NULL,
		[C2353] [int] NULL,
		[C2354] [nvarchar](64) NULL,
		[C2355] [nvarchar](64) NULL,
		[C2356] [nvarchar](64) NULL,
		[C2357] [nvarchar](64) NULL,
		[C2358] [nvarchar](64) NULL,
		[C2359] [nvarchar](512) NULL,
		[C2360] [nvarchar](64) NULL,
		[C2361] [nvarchar](64) NULL,
		[C2362] [int] NULL,
		[C2363] [nvarchar](1) NULL,
		[C2364] [nvarchar](48) NULL,
		[C2365] [nvarchar](80) NULL,
		[C2366] [nvarchar](50) NULL,
		[C2367] [nvarchar](48) NULL,
		[C2368] [nvarchar](48) NULL,
		[C2369] [nvarchar](48) NULL,
		[C2370] [nvarchar](48) NULL,
		[C2371] [date] NULL,
		[C2372] [date] NULL,
		[C2373] [date] NULL,
		[C2374] [date] NULL,
		[C2375] [numeric](12,2) NULL,
		[C2376] [numeric](12,2) NULL,
		[C2377] [numeric](12,2) NULL,
		[C2378] [numeric](12,2) NULL,
		[C2379] [numeric](12,2) NULL,
		[C2380] [date] NULL,
		[C2381] [nvarchar](8) NULL,
		[C2382] [nvarchar](1) NULL,
		[C2383] [int] NULL,
		[C2384] [nvarchar](4000) NULL,
		[C2385] [nvarchar](128) NULL,
		[C2386] [numeric](5,1) NULL,
		[C2387] [numeric](5,1) NULL,
		[C2388] [numeric](9,2) NULL,
		[C2389] [numeric](7,2) NULL,
		[C2390] [numeric](9,2) NULL,
		[C2391] [numeric](7,2) NULL,
		[C2392] [numeric](2,0) NULL,
		[C2393] [nvarchar](1) NULL,
		[C2394] [nvarchar](1) NULL,
		[C2395] [nvarchar](10) NULL,
		[C2396] [nvarchar](16) NULL,
		[MTAG] [nvarchar](80) NOT NULL,
		[CTAG] [nvarchar](80) NOT NULL
		); 

	INSERT INTO @tmp_ots_cl_calibration_update_i  
		SELECT C2301,
		C2302,
		C2303,
		C2304,
		C2306,
		C2307,
		C2308,
		C2309,
		C2310,
		C2311,
		C2312,
		C2313,
		C2314,
		C2315,
		C2316,
		C2317,
		C2318,
		C2319,
		C2320,
		C2321,
		C2322,
		C2323,
		C2324,
		C2325,
		C2326,
		C2327,
		C2328,
		C2329,
		C2330,
		C2331,
		C2332,
		C2333,
		C2334,
		C2335,
		C2336,
		C2337,
		C2338,
		C2339,
		C2341,
		C2342,
		C2343,
		c2344,
		c2345,
		C2346,
		C2347,
		C2350,
		C2351,
		C2352,
		C2353,
		C2354,
		C2355,
		C2356,
		C2357,
		C2358,
		C2359,
		C2360,
		C2361,
		C2362,
		C2363,
		C2364,
		C2365,
		C2366,
		C2367,
		C2368,
		C2369,
		C2370,
		C2371,
		C2372,
		C2373,
		C2374,
		C2375,
		C2376,
		C2377,
		C2378,
		C2379,
		C2380,
		C2381,
		C2382,
		C2383,
		C2384,
		C2385,
		C2386,
		C2387,
		C2388,
		C2389,
		C2390,
		C2391,
		C2392,
		C2393,
		C2394,
		C2395,
		C2396,
		MTAG,
		CTAG
		FROM inserted;

	SET @RowCount = (SELECT COUNT(*) FROM @tmp_ots_cl_calibration_update_d);

	SET @I = 1;

	WHILE (@I <= @RowCount) 

		BEGIN

		SELECT @mtag=mtag, @old_ctag=ctag  FROM @tmp_ots_cl_calibration_update_d WHERE ColumnID = @I;

		SELECT @assetnum = (SELECT i4201 FROM mt.inventory WHERE MTAG = @mtag);
		
		SELECT @new_ctag=ctag FROM @tmp_ots_cl_calibration_update_i WHERE ColumnID = @I;

		BEGIN
			SELECT 
			@new_C2301 = i.C2301, @old_C2301 = d.C2301,
			@new_C2302 = i.C2302, @old_C2302 = d.C2302,
			@new_C2303 = i.C2303, @old_C2303 = d.C2303,
			@new_C2304 = i.C2304, @old_C2304 = d.C2304,
			@new_C2306 = i.C2306, @old_C2306 = d.C2306,
			@new_C2307 = i.C2307, @old_C2307 = d.C2307,
			@new_C2308 = i.C2308, @old_C2308 = d.C2308,
			@new_C2309 = i.C2309, @old_C2309 = d.C2309,
			@new_C2310 = i.C2310, @old_C2310 = d.C2310,
			@new_C2311 = i.C2311, @old_C2311 = d.C2311,
			@new_C2312 = i.C2312, @old_C2312 = d.C2312,
			@new_C2313 = i.C2313, @old_C2313 = d.C2313,
			@new_C2314 = i.C2314, @old_C2314 = d.C2314,
			@new_C2315 = i.C2315, @old_C2315 = d.C2315,
			@new_C2316 = i.C2316, @old_C2316 = d.C2316,
			@new_C2317 = i.C2317, @old_C2317 = d.C2317,
			@new_C2318 = i.C2318, @old_C2318 = d.C2318,
			@new_C2319 = i.C2319, @old_C2319 = d.C2319,
			@new_C2320 = i.C2320, @old_C2320 = d.C2320,
			@new_C2321 = i.C2321, @old_C2321 = d.C2321,
			@new_C2322 = i.C2322, @old_C2322 = d.C2322,
			@new_C2323 = i.C2323, @old_C2323 = d.C2323,
			@new_C2324 = i.C2324, @old_C2324 = d.C2324,
			@new_C2325 = i.C2325, @old_C2325 = d.C2325,
			@new_C2326 = i.C2326, @old_C2326 = d.C2326,
			@new_C2327 = i.C2327, @old_C2327 = d.C2327,
			@new_C2328 = i.C2328, @old_C2328 = d.C2328,
			@new_C2329 = i.C2329, @old_C2329 = d.C2329,
			@new_C2330 = i.C2330, @old_C2330 = d.C2330,
			@new_C2331 = i.C2331, @old_C2331 = d.C2331,
			@new_C2332 = i.C2332, @old_C2332 = d.C2332,
			@new_C2333 = i.C2333, @old_C2333 = d.C2333,
			@new_C2334 = i.C2334, @old_C2334 = d.C2334,
			@new_C2335 = i.C2335, @old_C2335 = d.C2335,
			@new_C2336 = i.C2336, @old_C2336 = d.C2336,
			@new_C2337 = i.C2337, @old_C2337 = d.C2337,
			@new_C2338 = i.C2338, @old_C2338 = d.C2338,
			@new_C2339 = i.C2339, @old_C2339 = d.C2339,
			@new_C2341 = i.C2341, @old_C2341 = d.C2341,
			@new_C2342 = i.C2342, @old_C2342 = d.C2342,
			@new_C2343 = i.C2343, @old_C2343 = d.C2343,
			@new_C2344 = i.C2344, @old_C2344 = d.C2344,
			@new_C2345 = i.C2345, @old_C2345 = d.C2345,
			@new_C2346 = i.C2346, @old_C2346 = d.C2346,
			@new_C2347 = i.C2347, @old_C2347 = d.C2347,
			@new_C2350 = i.C2350, @old_C2350 = d.C2350,
			@new_C2351 = i.C2351, @old_C2351 = d.C2351,
			@new_C2352 = i.C2352, @old_C2352 = d.C2352,
			@new_C2353 = i.C2353, @old_C2353 = d.C2353,
			@new_C2354 = i.C2354, @old_C2354 = d.C2354,
			@new_C2355 = i.C2355, @old_C2355 = d.C2355,
			@new_C2356 = i.C2356, @old_C2356 = d.C2356,
			@new_C2357 = i.C2357, @old_C2357 = d.C2357,
			@new_C2358 = i.C2358, @old_C2358 = d.C2358,
			@new_C2359 = i.C2359, @old_C2359 = d.C2359,
			@new_C2360 = i.C2360, @old_C2360 = d.C2360,
			@new_C2361 = i.C2361, @old_C2361 = d.C2361,
			@new_C2362 = i.C2362, @old_C2362 = d.C2362,
			@new_C2363 = i.C2363, @old_C2363 = d.C2363,
			@new_C2364 = i.C2364, @old_C2364 = d.C2364,
			@new_C2365 = i.C2365, @old_C2365 = d.C2365,
			@new_C2366 = i.C2366, @old_C2366 = d.C2366,
			@new_C2367 = i.C2367, @old_C2367 = d.C2367,
			@new_C2368 = i.C2368, @old_C2368 = d.C2368,
			@new_C2369 = i.C2369, @old_C2369 = d.C2369,
			@new_C2370 = i.C2370, @old_C2370 = d.C2370,
			@new_C2371 = i.C2371, @old_C2371 = d.C2371,
			@new_C2372 = i.C2372, @old_C2372 = d.C2372,
			@new_C2373 = i.C2373, @old_C2373 = d.C2373,
			@new_C2374 = i.C2374, @old_C2374 = d.C2374,
			@new_C2375 = i.C2375, @old_C2375 = d.C2375,
			@new_C2376 = i.C2376, @old_C2376 = d.C2376,
			@new_C2377 = i.C2377, @old_C2377 = d.C2377,
			@new_C2378 = i.C2378, @old_C2378 = d.C2378,
			@new_C2379 = i.C2379, @old_C2379 = d.C2379,
			@new_C2380 = i.C2380, @old_C2380 = d.C2380,
			@new_C2381 = i.C2381, @old_C2381 = d.C2381,
			@new_C2382 = i.C2382, @old_C2382 = d.C2382,
			@new_C2383 = i.C2383, @old_C2383 = d.C2383,
			@new_C2384 = i.C2384, @old_C2384 = d.C2384,
			@new_C2385 = i.C2385, @old_C2385 = d.C2385,
			@new_C2386 = i.C2386, @old_C2386 = d.C2386,
			@new_C2387 = i.C2387, @old_C2387 = d.C2387,
			@new_C2388 = i.C2388, @old_C2388 = d.C2388,
			@new_C2389 = i.C2389, @old_C2389 = d.C2389,
			@new_C2390 = i.C2390, @old_C2390 = d.C2390,
			@new_C2391 = i.C2391, @old_C2391 = d.C2391,
			@new_C2392 = i.C2392, @old_C2392 = d.C2392,
			@new_C2393 = i.C2393, @old_C2393 = d.C2393,
			@new_C2394 = i.C2394, @old_C2394 = d.C2394,
			@new_C2395 = i.C2395, @old_C2395 = d.C2395,
			@new_C2396 = i.C2396, @old_C2396 = d.C2396
			FROM @tmp_ots_cl_calibration_update_i i, @tmp_ots_cl_calibration_update_d d  WHERE i.ColumnID = @I AND d.ColumnID = @I;
		END

			-- check each column in calibration for a change and call procedure to insert record for it
		BEGIN	
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2301',@old_C2301,@new_C2301;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2302',@old_C2302,@new_C2302;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2303',@old_C2303,@new_C2303;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2304',@old_C2304,@new_C2304;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2306',@old_C2306,@new_C2306;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2307',@old_C2307,@new_C2307;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2308',@old_C2308,@new_C2308;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2309',@old_C2309,@new_C2309;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2310',@old_C2310,@new_C2310;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2311',@old_C2311,@new_C2311;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2312',@old_C2312,@new_C2312;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2313',@old_C2313,@new_C2313;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2314',@old_C2314,@new_C2314;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2315',@old_C2315,@new_C2315;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2316',@old_C2316,@new_C2316;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2317',@old_C2317,@new_C2317;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2318',@old_C2318,@new_C2318;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2319',@old_C2319,@new_C2319;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2320',@old_C2320,@new_C2320;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2321',@old_C2321,@new_C2321;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2322',@old_C2322,@new_C2322;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2323',@old_C2323,@new_C2323;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2324',@old_C2324,@new_C2324;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2325',@old_C2325,@new_C2325;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2326',@old_C2326,@new_C2326;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2327',@old_C2327,@new_C2327;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2328',@old_C2328,@new_C2328;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2329',@old_C2329,@new_C2329;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2330',@old_C2330,@new_C2330;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2331',@old_C2331,@new_C2331;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2332',@old_C2332,@new_C2332;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2333',@old_C2333,@new_C2333;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2334',@old_C2334,@new_C2334;
		----	EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2335',@old_C2335,@new_C2335;
		----	EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2336',@old_C2336,@new_C2336;
		----	EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2337',@old_C2337,@new_C2337;
		----	EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2338',@old_C2338,@new_C2338;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2341',@old_C2341,@new_C2341;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2342',@old_C2342,@new_C2342;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2343',@old_C2343,@new_C2343;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2344',@old_C2344,@new_C2344;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2345',@old_C2345,@new_C2345;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2346',@old_C2346,@new_C2346;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2347',@old_C2347,@new_C2347;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2350',@old_C2350,@new_C2350;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2351',@old_C2351,@new_C2351;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2352',@old_C2352,@new_C2352;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2353',@old_C2353,@new_C2353;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2354',@old_C2354,@new_C2354;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2355',@old_C2355,@new_C2355;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2356',@old_C2356,@new_C2356;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2357',@old_C2357,@new_C2357;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2358',@old_C2358,@new_C2358;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2359',@old_C2359,@new_C2359;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2360',@old_C2360,@new_C2360;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2361',@old_C2361,@new_C2361;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2362',@old_C2362,@new_C2362;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2363',@old_C2363,@new_C2363;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2364',@old_C2364,@new_C2364;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2365',@old_C2365,@new_C2365;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2366',@old_C2366,@new_C2366;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2367',@old_C2367,@new_C2367;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2368',@old_C2368,@new_C2368;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2369',@old_C2369,@new_C2369;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2370',@old_C2370,@new_C2370;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2371',@old_C2371,@new_C2371;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2372',@old_C2372,@new_C2372;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2373',@old_C2373,@new_C2373;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2374',@old_C2374,@new_C2374;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2375',@old_C2375,@new_C2375;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2376',@old_C2376,@new_C2376;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2377',@old_C2377,@new_C2377;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2378',@old_C2378,@new_C2378;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2379',@old_C2379,@new_C2379;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2380',@old_C2380,@new_C2380;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2381',@old_C2381,@new_C2381;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2382',@old_C2382,@new_C2382;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2383',@old_C2383,@new_C2383;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2384',@old_C2384,@new_C2384;	
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2385',@old_C2385,@new_C2385;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2386',@old_C2386,@new_C2386;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2387',@old_C2387,@new_C2387;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2388',@old_C2388,@new_C2388;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2389',@old_C2389,@new_C2389;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2390',@old_C2390,@new_C2390;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2391',@old_C2391,@new_C2391;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2392',@old_C2392,@new_C2392;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2393',@old_C2393,@new_C2393;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2394',@old_C2394,@new_C2394;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2395',@old_C2395,@new_C2395;
			EXEC [mt].[ots_cl_log_insert] @current_user,@assetnum,NULL,@new_ctag,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'UPD','C2396',@old_C2396,@new_C2396;
		END

		SET @I = @I + 1
			
		END

	SET NOCOUNT OFF;
END TRY

BEGIN CATCH

    THROW;      --  Uncomment only if you need to see the error in debug or development;

END CATCH;

