UPDATE
  taClients
SET
  PaymentMethod           = @aPaymentMethod,
  CompanyRegNumber        = @aCompanyRegNumber,
  VATNumber               = @aVATNumber,
  ContractNumber          = @aContractNumber,
  ContractTerm            = @aContractTerm,
  BankSortCode            = @aBankSortCode,
  BankAccountNumber       = @aBankAccountNumber,
  Postal1                 = @aPostal1,
  Postal2                 = @aPostal2,
  Postal3                 = @aPostal3,
  PostalCode              = @aPostalCode,
  InternalClient          = @bInternalClient,
  AdhocAllowed            = @bAdhocAllowed,
  ImmediateAdhocInvoices  = @bImmediateAdhocInvoices,
  IndividualAdhocInvoices = @bIndividualAdhocInvoices,
  SingleLineInvoice       = @bSingleLineInvoice,
  InvoiceText             = @aInvoiceText,
  TaxTypeID               = @nTaxTypeID,
  EmailAddress            = @aEmailAddress,
  FinCategory             = @nFinCategory,
  PayrollRegister         = @aPayrollRegister,
  PayrollInstance         = @aPayrollInstance,
  PastelBillingCode       = @aPastelBillingCode
WHERE
  (ClientID = @nClientID)
