UPDATE
  taProspect
SET
  EstTurnOver        = @nEstTurnOver,
  OrderCompulsory    = @bOrderCompulsory,
  PeasaMember        = @bPeasaMember,
  SetaID             = @nSetaID,
  CompanyRegNumber   = @aCompanyRegNumber,
  VATNumber          = @aVATNumber,
  TaxTypeID          = @nTaxTypeID,
  EmailAddress       = @aEmailAddress,
  Postal1            = @aPostal1,
  Postal2            = @aPostal2,
  Postal3            = @aPostal3,
  PostalCode         = @aPostalCode,
  PaymentMethod      = @aPaymentMethod,
  BankSortCode       = @aBankSortCode,
  BankAccountNumber  = @aBankAccountNumber,
  LastChangeDate     = CURDATE()
WHERE
  (ProspectID = @nProspectID)
