UPDATE
  taCaseAction
SET
  CaseID = @nCaseID,
  CreatedByID = @nCreatedByID,
  Created = UNIX_TIMESTAMP(@dCreated),
  ActionID = @nActionID,
  ActionedByID = @nActionedByID,
  DateDiarised = UNIX_TIMESTAMP(@dDateDiarised),
  SetdownDate = UNIX_TIMESTAMP(@dSetdownDate),
  ActionComment = @aActionComment,
  Outsourced = @aOutsourced
WHERE
  CaseActionID = @nCaseActionID
