Instead of EXEC(@query)

try PRINT @query

Then try to execute what is printed.

If it's feasible you could do a Full Update, you would update the original record on the source database with the new data first. This way, your fact table always...

Jeffrey not exactly. Query should check Voucher Num. If it has GL Posted then take 'GL Posted'. If it doesn't have 'GL Posted' take 'GL Accrual Reversed' and 'GL...

SELECT *
  FROM final_output fo
 WHERE [G/L Transaction Type Desc] = 'GL Posted'
    OR ([G/L Transaction Type Desc] <> 'GL Posted'
  ...

DELETE fo
  FROM final_output fo
 WHERE EXISTS(SELECT 1
                FROM final_output fo2
...

I have developed two additional versions of the function and incorporated Microsoft's GENERATE_SEQUENCE in a test script.

The code for dbo.GENERATE_SEQUENCE is provided in the script article. It is written as...

The measurements for the code above includes the table allocation as well as the WHILE loop and the final SELECT?  In the code above the STATISTICS TIME, IO only...

Another interesting thing is that you simulated the manual process of crossing out numbers on paper by deleting them.

It's a bloody shame that the use of GENERATE_SERIES() defeats minimal...

It's basically a primes sieve, but instead of ticking...

Despite its appearance, this process seems slow at first glance; however, it actually exhibits impressive speed, computing all prime numbers below one million in just two seconds.

SET...

It's coming... According to the way they handled things like GENERATE_SERIES(), etc,...

Ok... I'm a little gobsmacked... I ran your code with zero changes and it's riddled with syntax errors and,yet, it ran without error.

What is the following supposed...

As one query

DECLARE @maxNumber INT = 1000;

WITH BitArray AS (
    SELECT [value] AS Id, 1 AS Bit FROM generate_series(1, (@maxNumber - 1) /...

Yes but the whole...

including p.N%6 IN(1, 2) It does increase the performance a bit, so I would argue it is appropriate. It changes the number of prime candidates from n/2...