UPDATE
  taClients
SET
  GroupName          = @aGroupName,
  ClientStatus       = @bClientStatus,
  FinNumber          = @aFinNumber,
  EstTurnOver        = @nEstTurnOver,
  IndustryID         = @nIndustryID,
  SubIndustryID      = @nSubIndustryID,
  SetaID             = @nSetaID,
  ReferredByClientID = @nReferredByClientID,
  ClientType         = @aClientType,
  CreditLimit        = @nCreditLimit,
  PaymentTerms       = @nPaymentTerms,
  OrderCompulsory    = @bOrderCompulsory,
  EmployersOrganisation = @aEmployersOrganisation,
  ParentClientID     = @nParentClientID
WHERE
  (ClientID = @nClientID)
