I see many people that site things like a lack of training at work, etc, etc.

Tell me... if you have a degree, who paid for it?  How did you...

One more thing...

The create table and create index code was created before any rows were added to the temp tables.  Not sure why the run time grew like that.  ...

Hello,

I have found the problem, in my indexes i forgot XKRES table I missed that there is difference: XHRES and XKRES.

After preparing the indexes now uses all...

I am getting an error

Msg 468, Level 16, State 9, Procedure dbo.WIP_Query_V2, Line 462 [Batch Start Line 2]
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS"...

You need to remove the drop existing bit, as there is no existing index on a new table.

The optimiser should be able to simplify the query to remove the nesting so it might not make much difference.

One of the big advantages...

The optimiser should be able to simplify the query to remove the nesting so it might not make much difference.

One of the big advantages of putting...

The optimiser should be able to simplify the query to remove the nesting so it might not make much difference.

One of the big advantages of putting you results...

The optimiser should be able to simplify the query to remove the nesting so it might not make much difference.

One of the big advantages of putting you results into a...

You can simplify the query to this:

SELECT COUNT(*)
  FROM BSEG I
  LEFT JOIN BKPF H 
         ON...

• This reply was modified 8 months, 2 weeks ago by  Jonathan AC Roberts.

Here is a script for getting the definition of temp tables:

https://www.sqlservercentral.com/scripts/get-temp-table-definition

https://learn.microsoft.com/en-us/sql/relational-databases/user-defined-functions/scalar-udf-inlining?view=sql-server-ver16

This might be more efficient:

;WITH CTE AS
(
    SELECT *,
           ROW_NUMBER() OVER (ORDER BY (SELECT...

SELECT Color,
       SampleType,
       SUM(SampleValue) SampleValue
  FROM #SampleData
 GROUP BY Color, 
   ...

From ChatGPT 4:

The provided deadlock XML contains a lot of information, but let's focus on the core elements to diagnose and address the deadlock issue.

First, let's break down the XML...