shel, you probably also want to add a check of effdate<=termdate, because sometimes ops "voids" affiliations that they can't delete by putting the termdate<effdate.

You need to be checking the affiliation effective dates on those tables to really get what you're looking for, and probably the affiltype of 'service' or 'group'. You also don't...

you don't have to use recursion to do the grouping. Still put your aggregates in your SELECT, add a GROUP BY date clause to the end, problem solved

SELECT <thing>
WHERE date IN ( Query1 - make sure it only returns the date values)

to do what, data entry? Manage the tables?

or do something kludgy like have a different dataset with the interaction data and do a lookup for what you wanted for the last few columns

ok, so how about this, why are the tables unavailable? Can you do something to make sure they are all available as a first step, or to identify which are...

As for Shakespeare, "methinks the lady doth protest too much" (i.e. perhaps he was poking fun at himself as well when referencing brevity)

I get the 50 minute limit...

Decide when you want the person to start walking, calculate the difference between start time and current time, apply the distance function for that many time increments. it's not real,...