I was thinking more about this - realized we can do this:

SELECT weekend_day_count=y/7-x/7+(y+1)/7-(x-1)/7
   FROM (VALUES(DATEDIFF(DAY,-53690,'1899-01-01') + 1,DATEDIFF(DAY,-53690,'1900-01-14') + 1))x(x,y)

We can specify the anchor date as...

I agree with you, Steve. I do have one observation and one question.

Where I currently work there are a LOT of Excel and MS Access applications out there. I'm...

Just one more thing - be aware of the implicit conversions that DATEDIFF performs when using the DATE or DATETIME2 data types or string dates.  Unless you really need dates...

• This reply was modified 5 years, 8 months ago by Jeffrey Williams.

We can make a simple change to Jacob's solution to fix the problem:

DECLARE @test_dates TABLE (start_date DATE, end_date DATE);

INSERT INTO @test_dates (start_date,end_date) VALUES 
('20180301','20180430'),   ...

How are you importing the CSV file into the database?  What is the agent job doing - is it just running T-SQL code or is it executing something else?

For something...

I always imagined doctors dictating into a voice recorder, and then other people in the office actually deal with the paperwork. If that's not how it works, then that's...

In the OLEDB destination - change the commit and batch sizes from the default values.  The default values essentially send all 70 million rows as a single transaction which then...

Shifting gears a bit, I wish that they had actually standardized the underlying stored date and time as decimal values where the integer portion is the number of days...

Ah... almost forgot.  One of the things that MS did very, VERY wrong is how they interpret the (secondary ANSI) format of YYYY-MM-DD when used for direct conversions from...

Scott?  Again????  :):):)

Declare @schedStart varchar(25) = '2020-06-07-12.30.00.00000';

 Select @schedStart
      , stuff(stuff(stuff(@schedStart, 11, 1, ' '), 14, 1, ':'), 17, 1, ':')
   ...

Thanks,

I have read & done this already & the current issue is accessing SSIS via the Tools >> Extensions because it doesn't appear in the available choices from File...

🙂

Scott?  🙂

After installing Visual Studio - you use the Visual Studio Installer to modify the installation and add/remove these items.  This is clearly documented in the links provided.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs