Categories

Follow our news:

Follow canonburysvcs on Twitter Follow Canonbury Services on Facebook Follow Canonbury Services' news by RSS Follow Canonbury Services' news by Atom Follow Canonbury Services' news by email

NEWS & TECH BLOG

Category: SQL queries

Check email addresses

Recover deleted records

Aggregate SQL queries in GoldMine

Distribution lists in GM

SQL date format

GoldSync and server time

Alerts in GoldMine

Query records, including history

Making sense of TLog entries

Contact list with email addresses

Where are counters kept in GoldMine?

Search all fields in GoldMine

Top n contacts in each country

Keep track of imports

Group from influencers

Search all phone fields

Another query for extracting email addresses

Find records with no primary email address

Extract a list of e-mail addresses

Which SQL version?

Who has got what in the Calendar?

How to use GM logs for forensics

Add a unique reference to an import file

How to identify primary email addresses

Script to find duplicate records

Find out where your linked docs live

Reviving lost opportunities

SQL query on GM group

Finding duplicate contact2 entries

Beating the 10,000 record SQL limit in GM

Creating a date range table

Numeric data in non-numeric fields

Recovering lost records in GM

Useful SQL formatting tool

Identifying users with overflowing inboxes

Clean up your unused fields

Query to show attachment paths

Query to show Long Text / Image fields

NULLS and empty fields

Taming the ‘previously viewed’ list