Introduction There are two stages to follow when importing records into GoldMine from an Excel data source. The first is the preparation of the data in Excel, and the second is the using the import feature of GoldMine. This guide should outline the key steps and help you understand the...
Day: March 3, 2010
GoldMine SQL Query – Show Duplicate E-mail Addresses
select address2, contsupref from contsupp where contsupref <>'' and rectype='p' and contact='E-mail Address' and contsupref in (select contsupref from contsupp group by contsupref having count(contsupref) >1) order by contsupref
GoldMine SQL Query – Duplicate Records based on Company
Many clients have databases that have duplicate records. The SQL query below will return information based on the company name being duplicated in the database. select company,contact,address1, address2, zip,phone1 from contact1 where company <>'' and company in (select company from contact1 group by company having count(*) >1) order by company