Here is one suggestion, uses a recursive CTE
😎

USE TEEST;
GO
SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#Employees') IS NOT NULL DROP...

As we do on this site, we don't assume, we state the facts.
So, just to put things into perspective, some solutions are less equal than others, there are cardinality induced...

Quick question, as there is no duration data type in SQL Server, why not simply record the start and end date times and when needed, simply calculate the...

EntityFramework(EF) can use DATETIME, done so on many project, may take a "little" convincing of the developers though. EF unfortunately uses DATETIME2(7) by default, which is simply a waste of...

TSB was like many others, a disaster waiting to happen. Even when voicing concerns with similar institutes, no one would listen and let alone do anything. This is not about...