I can't say that I understand your question. What do you mean by: "--ex "t"  has 1,200 , "t1"  1,100 means i want to see 100 to 99 t2 does not...

This will work for all dates between 1800 and 2400, it's more efficient than my previous proposed method

DECLARE @Eff_DateDATE;
DECLARE @Exp_DateDATE;

SET @Eff_Date = '01/01/2020';
SET @Exp_Date = '01/01/2021';

SELECT DATEDIFF(dd,@Eff_Date,@Exp_Date)
...

If you install this table valued function you could do it like this:

DECLARE @Eff_DateDATE;
DECLARE @Exp_DateDATE;

SET @Eff_Date = '01/01/2020';
SET @Exp_Date = '01/01/2021';

SELECT COUNT(Value) AS Days
  FROM...

I submitted a script to truncate tables that have referencing foreign keys. It doesn't do anything with triggers though I'm sure it can fairly easily be amended to do that....

SELECT u.*
  FROM (SELECT DISTINCT fl_group
          FROM Freelancer t) t
 CROSS APPLY(SELECT TOP(2) *
   ...

Have you tried searching the internet for the error "0xC020844B"?

It looks like a timeout.

Yes, good point

;WITH cte AS
(
SELECT * 
  FROM (VALUES (1,'ABD'),
 ...

;WITH cte AS
(
SELECT * 
  FROM (VALUES (1,'ABD'),
               (1,'ACD'),
   ...

John Roberts- Not sure about the errors, I don't get these when I use any of the code I've included. The 2 CREATE TABLE statements and the DELETE all...

Your SQL gives errors:

Msg 1767, Level 16, State 0, Line 42
Foreign key 'FK_ACCT_CHILD_TABLE' references invalid table 'dbo.ACCT'.
Msg 1750, Level 16, State 0, Line 42
Could not create constraint....

Can you post your problem?

You would normally write the left join as:

;WITH cte_A AS ( SELECT * FROM (VALUES(1, 'A', 10),(2, 'B', 20), (3, 'C', 30)) AS data(key_col, col1, col2)
), cte_B...

As the OP is using SQL 2017 there is an even easier way to get the results:

;with cte as
(
    select *
   ...

Hey Jon,

I troll these forums looking at other peoples issues so I can have a better understanding when I run into issues of my own..  That being said I'm...

;with cte as
(
    select *
      from (values ('1230000045'),
           ...