What is your question?

Try shredding your xml in a CTE, then do the count/group by using the CTE as source

• This reply was modified 5 years, 11 months ago by DesNorton.

There is a typo in the explanation.  The date format is given for 103 and not 101

NO.  DO NOT store decimals as varchar.

Find the error in the code that is doing the rounding.  What data types are being used in the UI?

Trace the call to the...

You are not giving us much to work with.  But the 2 Clustered Index Scans are not doing you any favours

This might help ...

SELECT jsonpayload = STUFF(jsonpayload, Start.Pos, Fin.Pos -1, '')
FROM YourTable
CROSS APPLY (SELECT CHARINDEX('?', jsonpayload, PATINDEX('%dealsPermaLink: /%', jsonpayload))) AS Start(Pos)
CROSS APPLY (SELECT PATINDEX('%,Id%', SUBSTRING(jsonpayload, Start.Pos, LEN(jsonpayload))))...

• I would start by replacing the old style joins with the new join style.  However, because your SQL references cc.ManagerId in your WHERE clause, and no tables have an...

Duplicate of https://www.sqlservercentral.com/forums/topic/help-to-optimize-select-query

Please provide...

That would depend on the company that you work for.

Where I work, DBAs are responsible for keeping SQ:L running, while Developers are responsible for giving the DBAs grey hairs.  Yes,...

You should look at JOINs

SELECT i.Name, i.Age, m.Description AS IDNumber
FROM [INFO] AS i
INNER JOIN [MATION] AS m
   ON i.IDNumber = m.ID

This looks like you are trying to do an UPDATE. If so, then

UPDATE  YourTable
SET     columnB = CASE
   ...

Remove this part

PARTITION BY WhatWeight

I have not checked this against your spreadseet

WITH cteBase AS (
    SELECT  whb.ID, whb.grower, whb.block, whb.section, whb.year, whb.weight, whb.payclass
    ...

hi

here i am again with a noob question again:

i'm trying to do this:

case 
when columnA <> 0 
then columnB = 1 
else columnB
end

but it return error.

i used...