You are attempting to compute the result of raising 78.94 to the power of 365, which evaluates to approximately 3.27E+692.

This value exceeds the maximum representable number in the float data...

DROP TABLE IF EXISTS #label ;
-- Create the table
CREATE TABLE #label 
(
    plot int,
)

-- Populate the table with sample data
INSERT INTO #label(plot)
VALUES (1), (2),...

25 minutes is quite fast for a...

You can copy it to the clipboard and execute it by pasting into a query window and pressing F5.

But my suggestion was really...

How long does a full load of the DW take?

I think you might want something like this:

WITH CTE AS
(
    SELECT s.DocumentId,
           ROW_NUMBER() OVER...

• This reply was modified 3 years, 2 months ago by Jonathan AC Roberts. Reason: Edited SQL

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...