SQL Insert multiple rows on duplicate key update incorrect syntax

------ To update the exisiting records
UPDATE T2
   SET consult_id = T1.consult_id, enq_stats = T1.enq
  FROM (SELECT consultants.id, COUNT(enquiries.id) AS enq
          FROM consultants
          LEFT JOIN enquiries 
            ON consultants.id=consult_id
         WHERE enquiries.date_sent BETWEEN DATEADD(day, -100, CURRENT_TIMESTAMP) and 
               DATEADD(day, -1, CURRENT_TIMESTAMP)
         GROUP BY consultants.id) T1
  JOIN leader_stats T2 ON T1.consult_id = T2.consult_id
 
------ To insert as a new record if not exisit
INSERT INTO leader_stats(consult_id,enq_stats)
       (SELECT consultants.id, COUNT(enquiries.id) AS enq
          FROM consultants
          LEFT JOIN enquiries 
            ON consultants.id=consult_id
         WHERE enquiries.date_sent BETWEEN DATEADD(day, -100, CURRENT_TIMESTAMP) and 
               DATEADD(day, -1, CURRENT_TIMESTAMP)
         GROUP BY consultants.id) T1
  LEFT OUTER JOIN leader_stats T2 ON T1.consult_id = T2.consult_id
 WHERE T2.consult_id IS NULL

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:

-- Check this one
 INSERT INTO leader_stats(consult_id,enq_stats)
       SELECT consultants.id, COUNT(enquiries.id) AS enq
          FROM consultants
          LEFT JOIN enquiries 
            ON consultants.id=consult_id
         WHERE enquiries.date_sent BETWEEN DATEADD(day, -100, CURRENT_TIMESTAMP) and 
               DATEADD(day, -1, CURRENT_TIMESTAMP)
         GROUP BY consultants.id 
  LEFT OUTER JOIN leader_stats T2 ON consultants.consult_id = T2.consult_id
 WHERE T2.consult_id IS NULL
 
-- If the above query doesn't work, then create a temp table 
SELECT consultants.id AS consult_id , COUNT(enquiries.id) AS enq
  INTO #TempTable
  FROM consultants
  LEFT JOIN enquiries 
    ON consultants.id=consult_id
 WHERE enquiries.date_sent BETWEEN DATEADD(day, -100, CURRENT_TIMESTAMP) and 
       DATEADD(day, -1, CURRENT_TIMESTAMP)
 GROUP BY consultants.id
         
-- use the temp table in your INSERT and UPDATE statements
INSERT INTO leader_stats(consult_id,enq_stats)
SELECT consult_id,enq
 FROM #TempTable T1
 LEFT JOIN leader_stats T2 ON T1.consult_id = T2.consult_id
WHERE T2.consult_id IS NULL
 
UPDATE T2
   SET consult_id = T1.consult_id, enq_stats = T1.enq
  FROM #TempTable T1
  JOIN leader_stats T2 ON T1.consult_id = T2.consult_id

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33: