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!

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

Search results for query: *

  1. cuetipper

    Goldmine SQL Query help.

    That is awesome. Thanks.
  2. cuetipper

    Goldmine SQL Query help.

    I appreciate all your help. Thanks. Is there anyway to just add the company name or preferably the custid [KEY 5] to the query that goldmine wrote? SELECT NT.* FROM NOTES NT WHERE (NT.USERID = 'goldmine') AND ((dateadd( day, datediff(day, 0, NT.CREATEDDATE), 0) >= '2016-10-03' AND dateadd(...
  3. cuetipper

    Goldmine SQL Query help.

    Thanks for the reply. Looking at your script I see only one date. I really need to set a range, like oct3-23. I had already tried the query builder in goldmine, this is the script it gave me: SELECT NT.* FROM NOTES NT WHERE (NT.USERID = 'goldmine') AND ((dateadd( day, datediff(day, 0...
  4. cuetipper

    Goldmine SQL Query help.

    version 8.5.2.8. I have little experience in SQL. I am trying to write a query that will allow me to generate a list of any record that has been modified by a specific user in a given time. The results need to include the custid, the date it was modified, and the user that did so. My attempts...

Part and Inventory Search

Back
Top