/*
select * from [dbo].[Objects_tbl]
where [Id] = 'd0d9a3b0-27bb-40c6-a558-b17920568ab7'
*/

goto Next1
UPDATE Objects_tbl SET ProcStateCol01 = 'D.Hallo'
                       -- ObjectLastModDate = GetDate(),
                       , ObjectLastSavDate = GetDate()
					   , ObjectName = ObjectName + '-#Debug'
					   where [Id] = 'd0d9a3b0-27bb-40c6-a558-b17920568ab7'
Next1:

-- goto MyExit
delete from Objects_tbl where ID IN ('2c89ff6a-3b09-4b72-9be0-7aebf01af42e','2c89ff6a-3b09-4b72-9be0-7aebf01af43e','2c89ff6a-3b09-4b72-9be0-7aebf01af44e','2c89ff6a-3b09-4b72-9be0-7aebf01af45e')

insert into Objects_tbl (ID ,  ObjectClass ,                          ObjectPuid ,          ObjectName,         ObjectName2,   ObjectFromSiteID  , ObjectLastModDate)
                VALUES ('2c89ff6a-3b09-4b72-9be0-7aebf01af42e', 'I', 'ObjectPuid-#Debug1', 'ObjectName-#Debug', 'ObjectName-1', 'TC11ADDPLM-10-VMtc91' , GetDate())

insert into Objects_tbl (ID ,  ObjectClass ,                          ObjectPuid ,          ObjectName,         ObjectName2,   ObjectFromSiteID  , ObjectLastModDate)
                VALUES ('2c89ff6a-3b09-4b72-9be0-7aebf01af43e', 'I', 'ObjectPuid-#Debug2', 'ObjectName-#Debug', 'ObjectName-2', 'TC11ADDPLM-10-VMtc91' , GetDate())

goto MyExit
insert into Objects_tbl (ID ,  ObjectClass ,                          ObjectPuid ,          ObjectName,         ObjectName2,   ObjectFromSiteID  , ObjectLastModDate)
                VALUES ('2c89ff6a-3b09-4b72-9be0-7aebf01af44e', 'I', 'ObjectPuid{-#Debug1', 'ObjectName{-#Debug', 'ObjectName-1', 'TC11ADDPLM-10-VMtc91' , GetDate())

insert into Objects_tbl (ID ,  ObjectClass ,                          ObjectPuid ,          ObjectName,         ObjectName2,   ObjectFromSiteID  , ObjectLastModDate)
                VALUES ('2c89ff6a-3b09-4b72-9be0-7aebf01af45e', 'I', 'ObjectPuid{-#Debug2', 'ObjectName{-#Debug', 'ObjectName-2', 'TC11ADDPLM-10-VMtc91' , GetDate())


insert into Objects_tbl (ID ,  ObjectClass ,                          ObjectPuid ,          ObjectName,         ObjectName2,   ObjectFromSiteID  , ObjectLastModDate)
                VALUES ('2c89ff6a-3b09-4b72-9be0-7aebf01af45e', 'I', 'ObjectPuid{-#Debug2', 'ObjectName{-#Debug', 'ObjectName-2', 'TC11ADDPLM-10-VMtc91' , GetDate())

INSERT INTO
  dbo.JobControl_ObjectsProcessData_tbl
(
  Id
  Objects_tbl_ID,
  ProcessPacketName,
  ProcessState,
  ProcessTimeStart,
  ProcessTimeEnd,
  ProcessCMDLine,
  ProcessResultCode,
  ProcessResultMsg,
  ProcessResultExtendedData,
  ProcessResultHasWarning,
  ProcessResultLink,
  ProcessOnComputer,
  ProcessProcStateCol,
  ProcessPrgUsedVer,
  ProcessObjectSaveVersion,
  Row_isLastRes,
  TaskScheduler_tbl_ID,
  ProcessCategory,
  ProcessTimeDuration
)
VALUES (
   NEWID(),
  '2c89ff6a-3b09-4b72-9be0-7aebf01af45e',
  'ProcessPacketName',
  'ProcessState,
  'ProcessTimeStart,
  GetDate(),
  'ProcessCMDLine,
  'XX',
  'ProcessResultMsg,
  'ProcessResultExtendedData,
  'ProcessResultHasWarning,
  'ProcessResultLink,
  'ProcessOnComputer,
  'ProcessProcStateCol,
  'ProcessPrgUsedVer,
  'ProcessObjectSaveVersion,
  'Row_isLastRes,
  :TaskScheduler_tbl_ID,
  :ProcessCategory,
  :ProcessTimeDuration
);


MyExit:

           