I want the last TaskSeqNum for the last visitID for a set of personID's where value 1 and value 2 are not null (they can still have value 3 and value 4 but I don't care) and the TaskDate of the TaskSeqNum cannot be more than a year from a given date range. Also value 1 and 2 are integers and Value 1 must be less than X AND value 2 must be less then Y. If they don't have a task I don't want them. They will almost assuredly have a visit but if they don't I don't want them.
Table 1 looks like this Col1 Col 2 personID Name etc. Table 2 looks like Col 1 Col 2 Col 3 personID VisitID VisitDate etc Table 3 Col 1 Col 2 Col 3 Col 4 Col 5 Col 6 VisitID TaskSeqNum TaskDate TaskTime Value1 Value2
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.