UPDATE
  tbAppointmentTypes
SET
  ProductCategory = @aProductCategory,
  AppointmentType = @aAppointmentType,
  TypeDescription = @aTypeDescription,
  BillingRule     = @nBillingRule,
  UnitOfMeasureID = @nUnitOfMeasureID,
  IsService       = @bIsService,
  IsClientMatter  = @bIsClientMatter,
  AlwaysAllowed   = @bAlwaysAllowed,
  LeadTimeApplies = @bLeadTimeApplies,
  UseTypeRate     = @bUseTypeRate,
  InCoverRate     = @aInCoverRate,
  OutOfCoverRate  = @aOutOfCoverRate,
  AdhocRate       = @aAdhocRate,
  IsActive        = @bIsActive
WHERE
  (AttendanceTypeID = @nAttendanceTypeID)
