INSERT INTO taClientContacts
SELECT
  'Client' AS ContactType,
  @nClientID AS TypeID,
  Notify,
  Title,
  FirstName,
  Surname,
  Position,
  Email,
  TelephoneAreaCode,
  TelephoneNo
FROM
  taClientContacts
WHERE
  (ContactType = 'Prospect') AND
  (TypeID = @nProspectID)
