Viewing 15 posts - 2,086 through 2,100 (of 4,820 total)
SELECT count(*) FROM table
WHERE
DATEOFPURCHASE >= DATEADD(MONTH,...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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. ...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 5, 2017 at 11:29 am
That seems to work perfectly, and after getting my head around CROSS APPLY...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 5, 2017 at 11:20 am
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 5, 2017 at 10:35 am
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 5, 2017 at 9:16 am
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
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...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 5, 2017 at 9:08 am
I have also been unable to reproduce that behavior.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 5, 2017 at 8:45 am
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 5, 2017 at 8:36 am
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 5, 2017 at 7:59 am
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 5, 2017 at 7:49 am
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 5, 2017 at 7:31 am
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 5, 2017 at 7:22 am
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 5, 2017 at 7:13 am
Viewing 15 posts - 2,086 through 2,100 (of 4,820 total)