Tuesday, October 26, 2010

GoldMine : Using SQL to generate record counts from your database

Ever wonder how many primary contacts, secondary contacts, or history items you have in your GoldMine database? Here are three simple SQL Queries to give you an answer.

First, go to Tools>Filters & Groups>SQL Queries Tab. Copy and paste the queries into the top half of the screen then click the Query button.

For a count of primary contacts:
Select count(*) from contact1

For a count of secondary contacts:
Select count(*) from contsupp where rectype = 'C'

For a count of history records:
Select count(*) from conthist

3 comments:

Libin Huang said...

20160427libinhermes belt
michael kors handbags
reebok shoes
cheap jordans
michael kors uk outlet
true religion jeans
fitflops sale
true religion jeans
hermes outlet store
celine outlet online
police sunglasses
mulberry outlet
michael kors handbags
ralph lauren outlet
coach factory outlet
coach outlet
cheap ray ban sunglasses
polo ralph lauren
cartier sunglasses
bottega veneta outlet
true religion outlet
tiffany and co
cheap oakley sunglasses
ray-ban sunglasses
oakley sunglasses
ralph lauren outlet
michael kors handbags
tory burch shoes
beats by dre
michael kors outlet online
tory burch outlet online
lululemon outlet online
oakley sunglasses
oakley sunglasses wholesale
true religion jeans

xumeiqing said...

michael kors watches
true religion
ray ban outlet
true religion outlet
fitflops
coach outlet
tiffany and co
michael kors handbags
kate spade handbags
christian louboutin outlet
oakley sunglasses
hermes uk
hollister shirts
pandora charms
louis vuitton factory outlet
cartier watches
adidas nmd
coach outlet online
ralph lauren outlet
coach outlet
polo outlet
hollister clothing
timberland boots
ghd flat iron
stephen curry shoes
michael kors outlet
adidas pure boost
christian louboutin uk
air jordan uk
nike air max uk
michael kors handbags
cheap ferragamo shoes
discount nike shoes
supra shoes
longchamp outlet
ray ban sunglasses discount

Zheng junxai5 said...


zhengjx20160623
cheap rolex watches
fitflops
timberland outlet
coach outlet online
toms wedges
true religion jeans
replica rolex watches
ralph lauren outlet
kate spade outlet
michael kors outlet
cheap jordan shoes
michael kors outlet clearance
coach outlet store online
fit flops
christian louboutin shoes
nike air huarache
coach outlet
timberlands
concords 11
ralph lauren home
toms wedges
retro jordans 13
burberry outlet
cheap jordans
gucci outlet
coach factory outlet online
abercrombie outlet
cheap air jordans
lebron 12
coach outlet online
tory burch boots
hollister clearance
cheap oakley sunglasses
nike free uk
louis vuitton outlet stores
louis vuitton outlet online
michael kors outlet
supra footwear
nike uk
michael kors outlet online