Viewing 15 posts - 211 through 225 (of 984 total)
October 31, 2017 at 4:37 am
Can you provide some small sample data showing what you expect to happen to each row?
October 27, 2017 at 4:54 am
Can you provide the execution plan for this query?
Also, what indexes exist on the tables used?
October 27, 2017 at 4:42 am
October 26, 2017 at 9:34 am
October 26, 2017 at 8:05 am
I thought you were looking for records where the hour was between 06:00 & 18:00, but your query says between 08:00 & 14:00...
October 26, 2017 at 8:02 am
Grant Fritchey - Saturday, October 21, 2017 2:06 PMStill here I see.
Where else would we be?
October 22, 2017 at 10:02 am
Computerphile - Time Zones. https://www.youtube.com/watch?v=-5wpm-gesOY
October 20, 2017 at 8:25 am
GDPR compliance? mm'kay.
I would have thought it might be handy to have a few other GDPR-related flags in there, as there are some "features" of GDPR that can...
October 19, 2017 at 9:45 am
Check your error logs. Do you see any error messages, specifically, any of errors 823, 824, 825, 829?
If so, then you'll need to get your storage team involved.
October 18, 2017 at 7:20 am
October 17, 2017 at 6:57 am
What I would do is firstly change your Start/EndDate calculations to form a bit simpler to understand:
SET @EndDate = DATEADD(MONTH,DATEDIFF(MONTH,'20100101',GETDATE()),'20100101'); -- first of this month
SET...
October 16, 2017 at 6:40 am
October 13, 2017 at 5:26 am
Viewing 15 posts - 211 through 225 (of 984 total)