Mass change made on 10/20/2023 by DL

******************  Inventory Change

Begin Transaction

update mt.inventory set i4247 = 'BRADLEY WIGGINTON', i4202 = 'DT0529', i4241 = 'BRADLEY.R.WIGGINTON@LEIDOS.COM'
where i4202 = 'DT0087';

Commit transaction;

*************  Location Change - adding a new record ASSUMES THE ASSET HAS NOT BEEN CHECKED IN

Begin transaction

insert into mt.location (L2809, L2810, L2824, L2804, L2828, L2801, L2835, Mtag)
select '2023-10-20', '09:07:00', '2023-10-20', '09:07:00','BRADLEY WIGGINTON', 'DT0529', 'BRADLEY.R.WIGGINTON@LEIDOS.COM', mtag
from mt.location where L2801 = 'DT0087' and L2825 is null and L2802 is null and l2815 = 1;

commit transaction;


**************** Adding a New Record for checked out and checked in to replace a person who has left

Begin transaction

insert into mt.location (L2809, L2810, L2824, L2804, L2828, L2801, L2835, Mtag, L2825, L2816, L2833, L2802)
select '2024-01-22', '19:17:00', '2024-01-22', '09:17:00','ALAN BALLENGER', '04645', 'ALAN.BALLENGER@DYNETICS.COM', mtag, '2024-01-22', '19:17:00', 'ALAN BALLENGER', '04645' 
from mt.location where L2801 = 'DT0312' and L2825 is NOT null and L2802 is NOT null and l2815 = 1;

commit transaction;