Viewing 15 posts - 2,086 through 2,100 (of 4,820 total)
SELECT count(*) FROM table
WHERE
DATEOFPURCHASE >= DATEADD(MONTH,...
October 5, 2017 at 11:33 am
adisql - Thursday, October 5, 2017 11:24 AMsorry i mistaken 🙂i want last onemonth data .
A couple of ways to interpret that. ...
October 5, 2017 at 11:29 am
That seems to work perfectly, and after getting my head around CROSS APPLY...
October 5, 2017 at 11:20 am
October 5, 2017 at 11:03 am
You might try "ragged right" and see if that makes a difference, but the best alternative is to review your agreement(s?) with the provider(s?) and see if there's any mention...
October 5, 2017 at 10:35 am
October 5, 2017 at 9:13 am
That's not entirely outside of a DBA's duties. I guess the question is why would you need to test each individual data range over the last 20 years? Why not...
October 5, 2017 at 9:08 am
I have also been unable to reproduce that behavior.
October 5, 2017 at 8:45 am
October 5, 2017 at 7:59 am
October 5, 2017 at 7:49 am
October 5, 2017 at 7:22 am
Viewing 15 posts - 2,086 through 2,100 (of 4,820 total)