Viewing 15 posts - 916 through 930 (of 8,731 total)
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 ).
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
kbhanu15 - Thursday, October 5, 2017 7:28 AMThank you so much.
Do you understand the solution proposed?
October 5, 2017 at 7:58 am
I tried your script earlier and was able to produce the records with same...
October 5, 2017 at 7:15 am
Viewing 15 posts - 916 through 930 (of 8,731 total)