https://docs.microsoft.com/en-us/sql/t-sql/data-types/float-and-real-transact-sql?view=sql-server-ver15

Prior to SQL Server 2016 (13.x), conversion of float values to decimal or numeric is restricted to values of precision 17 digits only. This is no longer a restriction as...

READUNCOMMITTED and NOLOCK cannot be specified for tables modified by insert, update, or delete operations. The SQL Server query optimizer ignores the READUNCOMMITTED and...

READUNCOMMITTED and NOLOCK cannot be specified for tables modified by insert, update, or delete operations. The SQL Server query optimizer ignores the READUNCOMMITTED and NOLOCK hints...

READUNCOMMITTED and NOLOCK cannot be specified for tables modified by insert, update, or delete operations. The SQL Server query optimizer ignores the READUNCOMMITTED and NOLOCK hints in the...

Discount rates don't usually change that much. They are usually mandated by law or company policy. The most dynamic data element in this table is going to be the...

the TOP 1 doesn't works and this is the reason why I'm here. If there's a query to do this, and you want help me, good.....the rest is my...

If you want to apply discounts to discounts you can do it with CROSS APPLY

Select x.Price,
         A.Result1,
  ...

Look at the execution plan.

Also run it with:

SET STATISTICS IO, TIME ON

This is probably a couple of stupid questions that shows my ignorance, but if you never ask how will you learn... 🙂

<li style="list-style-type: none;">

1. Why are you doing...

Thank for the many replies....the idea is show the first row of others. The point is that I need to "call" same columns just to apply a filter into...

Try TOP(1) in a CROSS APPLY.

e.g.:

SELECT DISTINCT 
       m.ID, 
       m.Type, 
   ...

Hi I Did not mentioned earlier, This is my Live OLTP Database/Tables. So On top of the adhoc Queries  there are some another maintenance jobs as well as some...

I hadn't actually looked...

You haven't provided information on what indexes are on the tables.

Ideally FinalTAble will have a clustered index on Id and no other indexes.

I would then try creating clustered indexes on...

I have a Use case like.

We tried disabling all the index but still it's taking too much time. Even we have 5-8 hours maintain-ace window. We don't have partitioned...