UPDATE
  taClientProjects
SET
  ClientID           = @nClientID,
  ProjectName        = @aProjectName,
  ProjectDescription = @aProjectDescription,
  ConsultantID       = @nConsultantID,
  RiskLevelID        = @nRiskLevelID,
  ProjectTypeID      = @nProjectTypeID,
  ProjectPhaseID     = @nProjectPhaseID,
  ProductID          = @nProductID,
  StartDate          = @aStartDate,
  GoLiveDate         = @aGoLiveDate,
  EmployeeCount      = @nEmployeeCount,
  PayrollWeekly      = @nPayrollWeekly,
  PayrollFortnightly = @nPayrollFortnightly,
  PayrollMonthly     = @nPayrollMonthly,
  ProjectStatus      = @bProjectStatus
WHERE
  ProjectID = @nProjectID