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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by cuetipper
-
Goldmine SQL Query help.
That is awesome. Thanks.- cuetipper
- Post #8
- Forum: FrontRange Solutions: GoldMine
-
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(...- cuetipper
- Post #5
- Forum: FrontRange Solutions: GoldMine
-
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...- cuetipper
- Post #3
- Forum: FrontRange Solutions: GoldMine
-
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...- cuetipper
- Thread
- Replies: 7
- Forum: FrontRange Solutions: GoldMine
