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

Ok, sorry, I've never used BIML. Also I've only used memory optimised table once, and I found...

You cannot have DATA_COMPRESSION on memory optimised table, so there is no point in specifying it.

So remove that option and just leave: WITH (MEMORY_OPTIMIZED=ON)

You just need BEGIN/END around the statement.

Also, it will be more efficient to use EXISTS than SELECT COUNT(*).

IF EXISTS(SELECT * FROM [A]) BEGIN

  ...

You just need BEGIN/END around the statement.

Also, it will be more efficient to use EXISTS than SELECT COUNT(*).

IF EXISTS(SELECT * FROM [A]) BEGIN

    TRUNCATE...

Have you tried running taskmgr or perfmon to see which processes are using a lot of memory?