Try these 2 queries

UPDATE EmpNameTable
SET Empname = Empname + '_OLD'
WHERE Empname NOT LIKE '%[_]OLD' -- Do not update when already updated
  AND Empname NOT LIKE '85%'...

So, you already have the last day of the month.  Just subtract 1 day and you'll have the second last day

select DATEADD(DAY, -1, DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE())-1,...

It comes in file and then we have SSIS package to insert it into SQL table which has data type of varchar.  Now when we want to use the...

The ONLY way top guarantee the order of  the order of the ordering of the result set is to use an ORDER BY.

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, 12 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