UPDATE
  taCase
SET
  CaseClosedDate = UNIX_TIMESTAMP(@dCaseClosedDate),
  OutcomeAmount = @nOutcomeAmount,
  CostsAwarded = @aCostsAwarded,
  CaseComment = @aCaseComment,
  CaseOutcomeTypeID = @nCaseOutcomeTypeID,
  CaseOutcomeTypeBasisID = @nCaseOutcomeTypeBasisID,
  CaseOutcomeTypeDescriptionID = @nCaseOutcomeTypeDescriptionID
WHERE
  CaseID = @nCaseID