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.

Read  Committed...

AND, looking a bit closer, my code doesn't work correctly using the following data but the mod to pietlinden's code does, so use his code with the mod.

Here's the...

Of course lots of changes could be made to a db that would not be reflected in sys.dm_db_index_usage_stats.  For example, file(s) added; user(s) added/removed; permissions added/removed; etc..

The most likely causes:...

Add an asterisk to the end of the string; it won't hurt if it's not needed but is vital if it is needed.

SELECT

SUBSTRING(UCL.PROCEDURE_COMMENT,

CHARINDEX('*', UCL.PROCEDURE_COMMENT) + LEN('*'),

CHARINDEX('*', UCL.PROCEDURE_COMMENT + '*', --<<--

CHARINDEX('*',...

Although it seems odd, that's actually quite normal.  The KILLed process must rollback any data it needs to.  Issue a:

KILL XXX WITH STATUSONLY

command.  If it reports 0 and 0%, then...

To me, 50/50 on using a splitter for just the first 3.  Here's code using CHARINDEX & SUBSTRING:

DECLARE @string varchar(200)

SET @string = 'NAZARE|DEV|T||Current~NAZARE|DEV|T||Previous'

SELECT string, Lastname, Firstname, Middlename
FROM...

Looks like you're trying to do something like below.  Note that if multiple, different ProductIds are INSERTed at the same time, if ANY of them fail, ALL will be rolled...

This looks like it's supposed to be looking for the @current_proc_name value, not the literal string 'SOURCE', but then WTH do I know?

AND CHARINDEX('ALTER', @proc_source) <...

How is that, specifically, when the current clus index is an identity column?  You don't...