slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Data & Imports Forums - T-SQL & Queries
Forum to discuss general T-SQL questions and help with queries related to SalesLogix data. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to T-SQL & Queries | New Thread

View: Search:

Author

Thread: View Accounts with most recent history occuring before a certain date

Tom Burnett
Posts: 10

View Accounts with most recent history occuring before a certain date Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 18 Mar 08 4:34 PM

I need to be able to create a group containing accounts whose most recent history, exluding database changes, occured before a certain date. I know that there is a field called Lasthistorydate, but filtering on this will not get the job done due to a previous error by our business partner with a custom automated dialer (they didn't set it up to write to the Lasthistorydate field when it entered a note in the history table).

What SQL query will accomplish this? Select AccountID, MAX(CreateDate).....

I am just learning SQL,I How can I do this?

[Reply][Quote]

Tom Burnett
Posts: 10

Re: View Accounts with most recent history occuring before a certain date Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Mar 08 1:04 PM

Nevermind. I found my answer in the Thread "Nested "IN" Queries"

http://www.slxdeveloper.com/forum.aspx?forumid=6002&postid=3840

Thnx

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 5/20/2024 10:09:07 PM