Viewing 15 posts - 1,276 through 1,290 (of 7,614 total)
SELECT
COALESCE(P.DatabaseName, D.DatabaseName, T.DatabaseName, S.DatabaseName) AS DatabaseName,
CASE WHEN P.DatabaseName IS NULL THEN '' ELSE 'Yes' END AS Prod,
...
September 17, 2021 at 4:23 pm
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....
September 17, 2021 at 1:11 am
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...
September 16, 2021 at 10:20 pm
...
CAST(p.QTY * 100.00 / s.OH AS decimal(5, 2)) AS 'Instock %'
...
September 16, 2021 at 10:03 pm
WITH cde_a AS
(SELECT 'Berries' AS fruit_type,
'strawberries' AS fruit,
1 AS red
UNION ALL
SELECT...
September 15, 2021 at 6:46 pm
#1 is (way) too much overhead.
#2 is better. You want static code that is generated dynamically.
September 15, 2021 at 2:41 pm
In a DB I executed
alter database xxx set read_committed_snapshot ON
If I execute
set transaction isolation level read committed
Is the session with isolation level read committed or read committed snapshot?
Read Committed...
September 15, 2021 at 2:39 pm
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...
September 15, 2021 at 3:36 am
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:...
September 10, 2021 at 7:08 pm
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('*',...
September 9, 2021 at 6:00 pm
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...
September 8, 2021 at 10:57 pm
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...
September 8, 2021 at 3:17 pm
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...
September 7, 2021 at 8:36 pm
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) <... September 7, 2021 at 5:20 pm
Ah... be careful. Changing the clustered index on the quick fly could cost you everywhere else.
How is that, specifically, when the current clus index is an identity column? You don't...
September 7, 2021 at 5:19 pm
Viewing 15 posts - 1,276 through 1,290 (of 7,614 total)