https://techcommunity.microsoft.com/t5/sql-server/sql-server-2016-minimal-logging-and-impact-of-the-batchsize-in/ba-p/385537

Table IndexesRows in table   Hints               With or Without TF...

https://techcommunity.microsoft.com/t5/sql-server/sql-server-2016-minimal-logging-and-impact-of-the-batchsize-in/ba-p/385537

Table IndexesRows in table   Hints               With or Without TF 610 ...

Sure, it's above; I posted it years ago, when this q was first asked.

Actually I should adjust it again, you only need to calc the very first Friday, from then...

• This reply was modified 4 years, 3 months ago by ScottPletcher.
• This reply was modified 4 years, 3 months ago by ScottPletcher.
• This reply was modified 4 years, 3 months ago by ScottPletcher.

Fwiw in 2021.  In the FROM clause use dbo.fnTally and CROSS APPLY (both twice) to hierarchically generate the first 7 days of each month.  Then in the WHERE...

I believe the calc should be:

CAST(((f.TOTFCST - f.TOTHIST) * 100.00) / f.TOTHIST AS decimal(5, 2))

I have no idea at all why you are subtracting 1 from the quotient in your...

Fwiw in 2021.  In the FROM clause use dbo.fnTally and CROSS APPLY (both twice) to hierarchically generate the first 7 days of each month.  Then in the WHERE clause...

If you add the clustering before you add the data, make sure that you use WITH(TABLOCK) on the INSERT INTO statement to help take advantage of "Minimal Logging", which...

You need to cluster tables #SmallerRange and #LargerRange on the the JOIN columns: ( VID, IorO, OtherLocationID ).  If those 3 column values are unique in one/both of the tables,...

SELECT OBJECT_NAME(object_id) AS object_name, OBJECTPROPERTYEX(object_id, 'BaseType') AS object_type

FROM sys.sql_modules

WHERE definition LIKE N'%<string_you''re_looking_for>%'

ORDER BY 2, 1

SELECT
    COALESCE(P.DatabaseName, D.DatabaseName, T.DatabaseName, S.DatabaseName) AS DatabaseName,
    CASE WHEN P.DatabaseName IS NULL THEN '' ELSE 'Yes' END AS Prod,
  ...

Best is to move the SUM() into a derived table, like so:

SELECT F.LOC AS 'Chain', F.DMDUNIT AS 'Item', D.DESCR AS 'Item Attributes. Description', D.U_PRODUCT_CATEGORY AS 'Item Attributes....

You're welcome!

Btw, you got 0 in the original calc because 2/100 is 0.02.  But, since the values were integer, SQL makes the result integer and thus 0 only (the .02...

...

CAST(p.QTY * 100.00 / s.OH AS decimal(5, 2)) AS 'Instock %'

...

WITH cde_a AS
(SELECT 'Berries' AS fruit_type,
        'strawberries' AS fruit,
        1 AS red
UNION ALL
SELECT...

#1 is (way) too much overhead.

#2 is better.  You want static code that is generated dynamically.