Ok, firstly, then, let's start by creating a Calendar Table. This is a fairly simple one that I grabbed from one of my Sandbox databases, but should be enough for...

• This reply was modified 4 years, 11 months ago by Thom A. Reason: I can't spell Calendar, apparently

With respect, this does not surprise me; I did mention that the Function was flawed in my above...

Most likely refreshing intellisense will clear the "error". It's more a warning, not an error, though; like Google Chrome telling you that "colour" is wrong because it defaults to American...

The CASE expression in your SQL seems overly complicated

CASE WHEN Row_Num < Row_Num + Row_Num THEN 'False' ELSE NULL END

Any positive number will be less than itself...

My points about the TVF you have still apply though, tanehome. A Multi-line table value function, with a WHILE is going to be very poor for performance. You really want...

Having a separate table for the holidays isn't a problem; I personally (at the office) use a separate table to store holidays; mainly as i store some additional meta data...

Ok, that function needs a massive change anyway, it's a Multi-line table value function and it's using a WHILE; both are (with respect) absolutely terrible for performance. What is the...

• This reply was modified 4 years, 11 months ago by Thom A.

What were the attempts you made to make it into a iTVF as well, and what were the error(s) you got?

Honestly, this is why I personally find it easier to just store anything in UTC if I'm ever working with time sensitive data, or multiple timezones (and I include the...

Surprised, Ed, you didn't notice that there's also a few  +xx:45 timezones too. >_< (New Zealand is "responsible" for one of those.)

Ran into that problem the other week, when sorting out an event that changed from being a real...

Greenwich Standard...

AT TIME ZONElooks like it is aware that DST changes on different dates in most timezones. Take the following:

SELECT CONVERT(datetimeoffset(0),'2020-09-28T14:00:00+01:00') AT TIME ZONE 'Eastern Standard Time' AS...

• This reply was modified 4 years, 11 months ago by Thom A.

You are absolutely right. However, the missing DLL's are part of the MSFT 2008R2 operating system, which means that our predecessor never evaluated the chance future operating systems might...

Even if you were to us 2008 packages in SQL Server 2016, that wouldn't solve the missing DDLs; they'd still be missing. If you're missing DDLs for the packages to...