
Begin Transaction

  Create table mt.asset_xfer(
  assets char(30));

Commit TRansaction;


Begin Transaction

	BULK INSERT METX.mt.asset_xfer
	FROM 'E:\ProgramData\Work\Location-change-20260311.csv'
	WITH
	(
        DATAFILETYPE = 'char',
        FIELDTERMINATOR=',',
        FIRSTROW=1,
        ROWTERMINATOR = '\n'
	)
	GO

commit transaction;

Begin Transaction
	update mt.inventory 
	set i4247 = 'TRAVIS HARLEY', I4202 = '658101', I4241 = 'TRAVIS.M.HARLEY@DYNETICS.COM'
	from mt.inventory
	     Inner Join mt.asset_xfer 
		 on (mt.asset_xfer.assets = mt.inventory.i4201)
	
Commit transaction;