DMW - Deleting multiple documents

BEGIN TRAN

  DECLARE @DeletingDoc TABLE

  ( deldoc_DocID BIGINT,

   deldoc_reason NVARCHAR (max),

   deldoc_srvcode NVARCHAR (20),

   deldoc_ActionedByUser NVARCHAR (60) 

  )

        INSERT INTO @DeletingDoc (deldoc_DocID) SELECT DocumentID FROM Document WHERE DocumentID IN (335598)

  SELECT DocumentID, IsDeleted FROM Document WHERE DocumentID IN (SELECT deldoc_DocID FROM @DeletingDoc)

  SELECT * FROM Deletion WHERE DocumentID IN (SELECT deldoc_DocID FROM @DeletingDoc)

  -- Update @DeletingDoc table with the other values

  UPDATE @DeletingDoc 

  SET 

    deldoc_reason = 'Manually marked as deleted – Ref #36309555842', 

    deldoc_srvcode = 'WinscribeText', 

    deldoc_ActionedByUser = '1000'

  -- Update Document table (IsDeleted = 1)

  UPDATE [Document] SET isDeleted = 1 WHERE DocumentID IN (SELECT deldoc_DocID FROM @DeletingDoc)

  --Insert DocumentIDs to the Deletion table

  INSERT INTO dbo.[Deletion] ([DocumentId], [ActionedByUser], [ActionedByServiceCode], [Reason], [DateTimeDeletion])

  SELECT deldoc_DocID, deldoc_ActionedByUser, deldoc_srvcode, deldoc_reason, GETDATE() FROM @DeletingDoc

  SELECT DocumentID, IsDeleted FROM Document WHERE DocumentID IN (SELECT deldoc_DocID FROM @DeletingDoc)

  SELECT * FROM Deletion WHERE DocumentID IN (SELECT deldoc_DocID FROM @DeletingDoc)

--ROLLBACK TRAN

COMMIT TRAN