SQL Learning Center - GoldMine

Use SQL queries to get answers from GoldMine

May 22, 2008

Customers and Prospect with no callback scheduled

by Doug Steinschneider @ 12:29 pm. Filed under MSSQL Calendar

Customers and Prospect with no callback scheduled

Description: This Query assumes you use key1 to track Contact Type such as ‘Prospect’ or ‘Customer’ and key4 for the rep’s userid

  1.  
  2. SELECT
  3.  c1.contact
  4. ,c1.company
  5. ,c1.key1 AS ContactType
  6. ,c1.key4 AS Rep
  7. ,c1.accountno
  8. FROM
  9.  contact1 c1
  10. WHERE
  11.  c1.key1 IN ('Prospect','Customer')
  12.  AND c1.key4 = 'Reps userid here'
  13.  AND c1.accountno NOT IN
  14.  (SELECT
  15.    accountno
  16.   FROM
  17.    cal
  18.   WHERE
  19.    rectype LIKE 'C%'
  20.    AND ondate > GETDATE())
  21.  
Bookmark:

These icons link to social bookmarking sites where readers can share and discover new web pages.
  • del.icio.us
  • Live
  • Google
  • Facebook
  • bodytext
  • StumbleUpon
  • Slashdot

Leave a Reply

You must be logged in to post a comment.

GoldMine SQL Tutorial:

General SQL Tutorials:

SQL Help Links:

Recommended Reading - SQL Books:

RSS:

Links:

Search For SQL Query:

GoldMine MS SQL Queries:

GoldMine dBase SQL Queries (LocalSQL):

22 queries. 0.071 seconds