The code from Google is actually quite a lot slower than the OP's original code.

If you want to keep with your original code there are a few things you can...

Maybe you could provide the code you have written so we could see why it's taking so long and see if there are any improvements that could be made?

I think...

 Do you know about holding down the Ctrl key while using the select the same position on  multiple lines? it's super useful (you can hold down shift to highlight...

Jonathan AC Roberts, I popped your code into my editor and ran it. Ran without modification. Kudos to you for doing that without being able to test. It almost...

You could...

• This reply was modified 6 years, 4 months ago by Jonathan AC Roberts.

I think this should do it:

DECLARE @startdate AS datetime

SET @startdate = '4/1/19';

WITH CTE AS 
(
    SELECT DISTINCT
       ...

1. Your SQL doesn't even compile. There is a left join without an ON:

   from @startDate
   left outer join Schedules day1 /* missing ON */
   left outer join EmployeeInformation Emp1...

It is an undocumented feature which sometimes works and sometimes doesn't. Which is why it is best to not use it.

There are a few discussion in sqlservercentral posts about when...

I think you should be using FOR XML PATH:

DECLARE @Country1 VARCHAR(3) = 'NL',
        @Country2 VARCHAR(3) = 'BE',
   ...

• This reply was modified 6 years, 4 months ago by Jonathan AC Roberts.

If you have SQL Server Enterprise you can use ONLINE = ON on the create index statement. This is supposed to allow transactions to continue on the table...

If you have SQL Server Enterprise you can use ONLINE = ON in the create index statement. This is supposed to allow transactions to continue on the table while the...

Hi there, I have around 12 views and that works perfect if I execute them individually but when I combine them using UNION ALL it takes long time to...

We had similar peaks at regular intervals, can't remember the exact interval, it might have been about 15 mins.

I think it might be to do with having a clustered pair...

I think you want an UPDATE followed...

Unless I'm misreading the given solution, it won't properly calculate the time difference correctly for entries that span a date boundary.   This is one of the many reasons...