UPDATE
  taClientBranchProducts
SET
  ConsultantID = @nConsultantID,
  SalesReferrerID = @nSalesReferrerID,
  SalesCloserID = @nSalesCloserID,
  TechnicalSpecialistID = @nTechnicalSpecialistID,
  JoinDate = @aJoinDate
WHERE
  (ClientBranchProductID = @nClientBranchProductID)
