Can you post your problem?

You would normally write the left join as:

;WITH cte_A AS ( SELECT * FROM (VALUES(1, 'A', 10),(2, 'B', 20), (3, 'C', 30)) AS data(key_col, col1, col2)
), cte_B...

As the OP is using SQL 2017 there is an even easier way to get the results:

;with cte as
(
    select *
   ...

Hey Jon,

I troll these forums looking at other peoples issues so I can have a better understanding when I run into issues of my own..  That being said I'm...

;with cte as
(
    select *
      from (values ('1230000045'),
           ...

with cte as
(
    select *
      from (values ('1230000045'),
           ...

They all produce the same results. There are usually many ways to get the same results from different queries, for example, all of these will also produce the same results:

You also have two commas in a row:

T1.ItemCode,

,Coalesce

Notepad++ is quite good for this.

You can open multiple files and perform a replace on all files in one go.

A table doesn't store data in order. You can only guarantee getting data back in a particular order if you use an ORDER BY clause.

Is there another column that you...

<table_source> ::=
{  
    table_or_view_name [ [ AS ] table_alias ] [ <tablesample_clause> ]
        [ WITH (...

You should use a windowed SUM:

select pt.CategoryName,
       pt.AgentDepartmentName,
       pt.TicketsOpened,
      ...

DECLARE abc CURSOR FOR
SELECT ROUTINE_NAME
  FROM INFORMATION_SCHEMA.routines
 WHERE ROUTINE_TYPE = 'PROCEDURE' 
   and right(ROUTINE_NAME,4)='Bulk' 
   and ROUTINE_NAME !='usp_Integration_CONTRAT_EMISSION_Bulk'
 order by case ROUTINE_NAME...

When you say Page File usage is up to 200% of the memory, what you are talking about is the size of the page-file not the page file actually being...

Insert into #TempInvoice (Tkey,Status,Amount)
SELECT TOP(1) Tkey,'First',Amount FROM #TempInvoice