Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Most active contact records

Useful SQL Queries

Most active contact records

by  goner  Posted    (Edited  )
(based on number of histories in the last month)
Note, this works only on SQL-based GoldMine...

SELECT company, count(ondate)as Activities
FROM contact1,conthist
WHERE contact1.accountno = conthist.accountno
AND MONTH(ondate) = MONTH(getdate())-1
AND YEAR(ondate) = YEAR(getdate())
GROUP BY company,contact1.accountno
ORDER BY Activities DESC
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top