Can you post the second query, and probably execution plan for it too?

How is the query you posted is invoked and how its resultet is used?

Not to forget - there are situations when definitions of workdays are different within the same organisation. Health, logistics, hospitality business, retail trading, etc. - they all typically have different...

No code can fix performance issues caused by faulty database design.

If you think otherwise - try to fix performance (and scalability) issues on msdb.

It's easy and flexible to include weekends in a Calendar table, usually with two flags one that says weekends, one that says holidays.  Sometimes Christmas falls on a...

Good Point Sergiy.

Public holidays are also excluded.   , but right now Id just like to solve the weekends and then see if there is a solution for hoildays as...

Do you ship on...

For the beginning MS  should not have stuffed SQL Server with  XML, JSON, columnstore, blob's other big data features which have nothing to do with relational algebra.

Placing big chunks of...

edited. See below

• This reply was modified 3 years, 8 months ago by  Sergiy. Reason: messy spelling and wording

I'm not sure who or what marked the post by fgrodriguez as spam but I'm reposting it here so that the de-spaminator doesn't delete it.

I'll also state I'm a...

It seems that a.oid and tm.oid are of different data types.

any reason for that?

Do records with different locale settings arrive within the same file?

most likely not. Different ERP systems could send dates in different formats, but those formats would be consistent within all...

Scott, you forgot about "Unknown".

Here is a simple JOIN version which also uses a single scan through the table and is less dependent on hardcoded values:

DECLARE @Ind...

I've had many managers in the past 20 years.  Some were good, some not so good, and some were terrible.  The not-so-good ones can sometimes be "trained" through demonstration...

Start with adding ROW_NUMBER() over PARTITION BY Month.

F.clems, if you need to use tricks and manipulation to bypass the system in order to get a good result, then the system is broken, don't you think?