Viewing 15 posts - 916 through 930 (of 8,731 total)
My advice is not to trust what others tell you. Just do a simple test and review the behavior using the execution plans.
First, let's create some sample data:
October 11, 2017 at 10:33 am
October 11, 2017 at 6:30 am
October 10, 2017 at 12:19 pm
If BULK INSERT is not an option, you could try using SSIS or some othere ETL tool that your company is already using. I would still try to push to...
October 10, 2017 at 7:09 am
Luis - Can you provide me the same for a month to month...
October 10, 2017 at 6:46 am
October 6, 2017 at 10:38 am
Steve,
I am looking for ... from exactly 1 month ago through right now.
can you...
October 5, 2017 at 12:00 pm
October 5, 2017 at 11:43 am
You got the first paragraph right.
About the approximate number of rows, I'd say that the number is pretty accurate. The reason for this warning is that some tables have...
October 5, 2017 at 11:23 am
Need to select last one month( from today to last 30 days ).
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
October 5, 2017 at 11:15 am
This migh also work.
DECLARE @Start datetime = DATEADD(YY, DATEDIFF(YY, 0, GETDATE()) - 20, 0);
WITH
E(n) AS(
SELECT n FROM (VALUES(0),(0),(0),(0),(0),(0),(0),(0),(0),(0))E(n)
),
E2(n)...
October 5, 2017 at 10:39 am
This would generate a test script for all dates from 20 years ago till today. It uses a YTD range.
DECLARE @Start datetime = DATEADD(YY, DATEDIFF(YY, 0,...
October 5, 2017 at 10:05 am
October 5, 2017 at 9:44 am
October 5, 2017 at 8:11 am
kbhanu15 - Thursday, October 5, 2017 7:28 AMThank you so much.
Do you understand the solution proposed?
October 5, 2017 at 7:58 am
Viewing 15 posts - 916 through 930 (of 8,731 total)