Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause

select wcid, year(rowdate) as year, month(rowdate) as month, day(rowdate) as day, count(distinct job) as jobOper 
into #avk
from viewjobtran
where rowdate >= '2023-07-01' and rowdate <= '2023-07-05'
and wc = '201000'
group by year(rowdate), month(rowdate), day(rowdate), wcid
order by year(rowdate), month(rowdate), day(rowdate), wcid
 
 
  with #avk1 (job, ceh)
as
(
    select distinct job, 
        (select wcid 
         from jobelement 
         where id = jobtran.jobelementid  
         and wcid = '201000') as jobOborotka
    from jobtran 
    where rowdate >= '2023-07-01' and rowdate <= '2023-07-05'
    and finalwhseid = 12
    
)
 
select ceh, count(job) as Сумма
from #avk1
where ceh is not null
group by ceh
 
drop table #avk, #avk1

        MySelectCommand.CommandText = @"select wcid, year(rowdate) as year, month(rowdate) as month, day(rowdate) as day, count(distinct job) as jobOper
into #avk
from viewjobtran 
 where rowdate >= @MyDateParam1 and rowdate <= @MyDateParam2
and wc = '" + MyComboData1 + @"'
group by year(rowdate), month(rowdate), day(rowdate), wcid
order by year(rowdate), month(rowdate), day(rowdate), wcid
 
select *
from #avk;
 
  with #avk1 (job, ceh)
as
(
    select distinct job, 
        (select wcid 
         from jobelement 
         where id = jobtran.jobelementid  
         and wcid = '" + MyComboData1 + @"') 
    from jobtran 
     where rowdate >= @MyDateParam1 and rowdate <= @MyDateParam2
    and finalwhseid = 12
    
)
 
 
select ceh, count(job) 
from  #avk1
where ceh is not null
group by ceh
 
drop table #avk";
 
 
            MySelectCommand.Parameters.Add("@MyDateParam1", SqlDbType.DateTime);
            MySelectCommand.Parameters["@MyDateParam1"].Value = dateTimePicker1.Value;
            MySelectCommand.Parameters.Add("@MyDateParam2", SqlDbType.DateTime);
            MySelectCommand.Parameters["@MyDateParam2"].Value = dateTimePicker2.Value;
            MySelectCommand.Connection = MyConnection;
            MySelectCommand.CommandTimeout = 0;
            System.Data.DataTable MyConnteyner = new System.Data.DataTable();
            SqlDataAdapter MyAdapter = new SqlDataAdapter(MySelectCommand);
            MyAdapter.Fill(MyConnteyner);
            if (MyConnteyner.Rows.Count > 0)
            {
                string uchastok = "";
                foreach (DataRow MyRow in MyConnteyner.Rows)
                {
                    if (uchastok != MyRow["wcid"].ToString())
                    {
                        uchastok = MyRow["wcid"].ToString();
                       // i++;
                       // MySheet.Cells[i, 1].Value = MyRow["sitewc"];
                        MySheet.Cells[i, 3].Font.Bold = true;
                        //i++;
 
                       /* MySheet.Cells[i, 1].Value = "ЗНП";
                        MySheet.Cells[i, 2].Value = "Код";
               */
                        range = MySheet.Range[i, 1, i, 6];
                        range.Font.Bold = false;
                        range.Borders[XlBordersIndex.xlAround].ColorIndex = XlColorIndex.xlColorIndexAutomatic;
                        range.Borders[XlBordersIndex.xlInsideAll].ColorIndex = XlColorIndex.xlColorIndexAutomatic;
                        range.HorizontalAlignment = XlHAlign.xlHAlignRight;
                        //i++;
                    }
 
                    MySheet.Cells[i, 1].Value = MyRow["year"]; //Год
                    MySheet.Cells[i, 2].Value = MyRow["month"];//Месяц
                    MySheet.Cells[i, 3].Value = MyRow["day"];//День
                    MySheet.Cells[i, 4].Value = MyRow["jobOper"];//Кол-во операций
                    MySheet.Cells[i, 5].Value = MyRow["wcid"];//Цех
                    MySheet.Cells[i, 6].Value = MyRow["job"];//ЗНП оборотка
        
 
                    range = MySheet.Range[i, 1, i, 6];
                    range.Borders[XlBordersIndex.xlAround].ColorIndex = XlColorIndex.xlColorIndexAutomatic;
                    range.Borders[XlBordersIndex.xlInsideAll].ColorIndex = XlColorIndex.xlColorIndexAutomatic;
                    i++;
                }
            }
            book.SaveAs(file_name);
            System.Diagnostics.Process.Start(file_name);
            
        }

if (reader.NextResult())