Viewing 15 posts - 541 through 555 (of 1,246 total)
Where clause looks wrong. OP wants all data from 23:00 to 7:00 the following morning.
You are absolutely right Lynn. I didn't catch until way after I'd posted.
What's...
October 25, 2017 at 12:36 am
If query performance is an issue, consider adding just the time portion as a calculated column to the base table. That way you'll be able to include it in indexes.
October 24, 2017 at 8:00 pm
However, you still have the issue of a Cartesian join between the...
October 24, 2017 at 12:49 pm
October 24, 2017 at 1:28 am
Jeff and Joe... If you haven't watched this before, it's well worth the time it takes to watch.
Joe, You'e name is and your work on relational division gets some...
October 22, 2017 at 7:11 pm
Here's my shot at this problem. Just to make life easy, I'll keep all...
October 22, 2017 at 2:17 pm
Jeff Moden - Saturday, October 21, 2017 8:28 PMYou need to use Gail's dynamic "Catch All Query" method on that one.
That is...
October 21, 2017 at 9:17 pm
October 21, 2017 at 8:08 pm
October 21, 2017 at 6:52 pm
October 21, 2017 at 4:55 pm
Well... I really am a big dumb animal... I forgot to unplug the table's RN column after running the times for the standalone table... And, we're back to previous numbers...
October 21, 2017 at 2:07 am
While we're at it... when all this first started and while I was waiting...
October 20, 2017 at 11:27 pm
October 20, 2017 at 8:57 pm
October 20, 2017 at 4:07 pm
Viewing 15 posts - 541 through 555 (of 1,246 total)