

--  This is a table for changing assets status - just a single column.

		Begin TRansaction
	
	CREATE TABLE [mt].[asset_update]
	(asset char(20));

    commit transaction;
	
Begin Transaction
	
		delete from mt.asset_update;

		BULK INSERT mt.asset_update
		FROM 'E:\ProgramData\Work\Deactivate.csv'
		WITH
		(
			FORMAT='CSV',
			FIELDTERMINATOR='|',
			FIRSTROW=2,
			ROWTERMINATOR = '\n'
		)
		GO

	Commit Transaction;	
	
	
	
	Begin TRansaction
		SET ansi_warnings Off;
		UPDATE mt.inventory
		SET mt.inventory.i4225 = 'INACTIVE', I4299 = 'I'
		FROM [METX].[mt].[asset_update]
			INNER JOIN mt.inventory
			ON ([METX].[mt].[asset_update].[asset] = mt.inventory.i4201);
			
	commit transaction;	
	
	