Viewing 15 posts - 271 through 285 (of 607 total)
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.
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 15, 2019 at 1:07 pm
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 15, 2019 at 1:05 pm
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
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 15, 2019 at 11:54 am
SELECT <thing>
WHERE date IN ( Query1 - make sure it only returns the date values)
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 15, 2019 at 11:43 am
to do what, data entry? Manage the tables?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 15, 2019 at 9:29 am
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
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 15, 2019 at 9:27 am
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 15, 2019 at 9:21 am
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 15, 2019 at 8:10 am
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 15, 2019 at 8:00 am
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...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 15, 2019 at 7:52 am
I'm sure that there are many folks out there that will disagree with...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 15, 2019 at 7:40 am
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,...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 14, 2019 at 7:42 am
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 14, 2019 at 7:20 am
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 13, 2019 at 9:37 am
Ah, thank you, Jonathan, for defining the term "metric".
In our case...
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 13, 2019 at 9:31 am
Viewing 15 posts - 271 through 285 (of 607 total)