Как сделать create table?

public async Task<List<MDrawSummarySpec>> GetDrawSummaryListAsync(Draw draw)
{
    List<MDrawSummarySpec> specs = new List<MDrawSummarySpec>();
    string sqlText = "dbo.spM29SelectDrawSummarySpec";
 
    try
    {
        using (SqlConnection sqlConnection = new SqlConnection(_connectionString))
        {
            await sqlConnection.OpenAsync();
 
            using (SqlCommand sqlCommand = new SqlCommand(sqlText, sqlConnection) { CommandType = CommandType.StoredProcedure })
            {
                SqlParameter pDrawID = new SqlParameter
                {
                    ParameterName = "@drawID",
                    Value = draw.DrawID,
                    SqlDbType = SqlDbType.Int,
                    Direction = ParameterDirection.Input
                };
                sqlCommand.Parameters.Add(pDrawID);
 
                using (SqlDataReader sqlDataReader = await sqlCommand.ExecuteReaderAsync())
                {
                    if (sqlDataReader.HasRows)
                    {
                        while (await sqlDataReader.ReadAsync())
                        {
                            specs.Add(new MDrawSummarySpec
                            {
                                SummaryID = (int)sqlDataReader["SummaryID"],
                                DrawID = (int)sqlDataReader["DrawID"],
                                KKS = sqlDataReader["KKS"]
                                    == DBNull.Value ? null : (string)sqlDataReader["KKS"],
                                Designation = sqlDataReader["Designation"]
                                    == DBNull.Value ? null : (string)sqlDataReader["Designation"],
                                PosName = (string)sqlDataReader["PosName"],
                                Material = sqlDataReader["Material"]
                                    == DBNull.Value ? null : (string)sqlDataReader["Material"],
                                Quantity = (double)sqlDataReader["Quantity"],
                                Measure = (string)sqlDataReader["Measure"],
                                UnitWeight = (double)sqlDataReader["UnitWeight"]
                            });
                        }
                    }
                }
            }
        }
 
        return specs = specs
            .OrderBy(s => s.PosName, new NaturalStringComparer())
            .ThenBy(s => s.Designation, new NaturalStringComparer())
            .ToList();
    }
    catch (SqlException sqlEx)
    {
        throw new ApplicationException(string.Format("T-SQL #{0} - {1}", sqlEx.Number, sqlEx.Message));
    }
    catch (Exception ex)
    {
        throw new ApplicationException(ex.Message);
    }
}

using System;
using System.ComponentModel;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using NativeExcel;
using System.Reflection;
using System.Data.SqlClient;
using System.Data;
 
 
namespace Exp_Exel
{
    public partial class Frm_Analiz_znp : Form
    {
        public Frm_Analiz_znp()
        {
            InitializeComponent();
        }
 
        private void Button1_Click(object sender, EventArgs e)
        {
            string MyComboData2 = (string)comboBox2.SelectedItem; /*подразделение*/
            DateTime MyDateData_c = dateTimePicker1.Value;
            DateTime MyDateData_po = dateTimePicker2.Value;
 
            //Вызов Экселя//
            string Path = System.Windows.Forms.Application.StartupPath + "\\Data\\";
            IWorkbook book = NativeExcel.Factory.OpenWorkbook(Path + "VesZNP.xls");
            Path = @"\\Docx\report\";
            string file_name = Path + DateTime.Now.ToFileTime().ToString() + "VesZNP.xls";
 
 
            book.SaveAs(file_name);
            book = NativeExcel.Factory.OpenWorkbook(file_name);
            IWorksheet MySheet = book.ActiveSheet;
            IRange range = MySheet.Range[1, 1, 1, 1];
            range.Rows.RowHeight = 1;
 
            MySheet.Cells[2, 1].Value = "Плановая трудоемкость по участкам и по машинам " + MyComboData2 + " за период с " + Convert.ToDateTime(MyDateData_c.Date.ToString().Substring(0, 10)) + " по " + Convert.ToDateTime(MyDateData_po.Date.ToString().Substring(0, 10));
 
            int i = 6;
 
            //Подключение к БД "test"//
            [COLOR="Red"]Connection_manager.Set_Connection("Data Source=test;Initial Catalog=test;Persist Security Info=True;User ID=roor; Password = password987654321");[/COLOR]
            Connection_manager.Set_month("10");
            DialogResult = DialogResult.OK;
 
            //подключение SQL - вывожу результат//
            SqlConnection MyConnection5 = Connection_manager.GetCurrentConnection();
            SqlCommand MySelectCommand5 = new SqlCommand();
 
           /* MySelectCommand5.CommandText = @"select distinct i.SlCode, i.FullName, i.SlCode + ' (' + i.FullName + ')' as Description 
 from viewjobelement je, job j, test.dbo.viewitems i, jobmatl jm
 where je.job = j.job and je.suffix = j.suffix and je.wcid = '" + MyComboData2 + @"' and enddate >= @MyDateParam1 and enddate <= @MyDateParam2
 and jm.job = j.job and jm.suffix = j.suffix and jm.itemID = i.ConstID and i.ItemTypesID = 4
 order by i.FullName";*/
 
           [COLOR="red"] MySelectCommand5.CommandText = @"CREATE TABLE #PR1(Job bigint, Suffix smallint, StatusRus nvarchar(100), StartDate datetime, EndDate datetime, BuhOrderCode nvarchar(100), BuhOrderDesc nvarchar(100), 
ItemID int, SLCode nvarchar(100), FullName nvarchar(500), ItemTypesID int, SN nvarchar(100), ProcessName nvarchar(100), [Route] nvarchar(100), 
IsTargetItem int, JobOperationID int, QtyReleased numeric(18, 8), QtyComplete numeric(18, 8), ElemNum int, WC int, WorksAspect nvarchar(100), SiteWC nvarchar(100), 
[Operation] nvarchar(100), Equipment nvarchar(100), EqModelPower nvarchar(100), Payable nvarchar(100), CorrectFactor numeric(18, 8), Profession nvarchar(100), 
PerformersQty int, [Rank] int, Valuation numeric(18, 8), Laboriousness numeric(18, 8), HasClosedOpers int, Reason nvarchar(100)) 
insert into #PR1 (Job, Suffix, StatusRus, StartDate, EndDate, BuhOrderCode, BuhOrderDesc, ItemID, SLCode, FullName, ItemTypesID, SN, ProcessName, [Route], JobOperationID, QtyReleased, QtyComplete, ElemNum, WC, WorksAspect, SiteWC, [Operation], Equipment, EqModelPower, Payable, CorrectFactor, Profession, PerformersQty, [Rank], Valuation, Laboriousness, HasClosedOpers, Reason) 
EXECUTE dbo.GetRptPurpleTrud '2023-03-01', '2023-03-30', 207000, null;
delete from #pr1 where Laboriousness = 0";[/COLOR]
         
 
            MySelectCommand5.Parameters.Add("@MyDateParam1", SqlDbType.DateTime);
            MySelectCommand5.Parameters["@MyDateParam1"].Value = MyDateData_c.Date;
            MySelectCommand5.Parameters.Add("@MyDateParam2", SqlDbType.DateTime);
            MySelectCommand5.Parameters["@MyDateParam2"].Value = MyDateData_po.Date;
            MySelectCommand5.Connection = MyConnection5;
            MySelectCommand5.CommandTimeout = 0;
            System.Data.DataTable MyConnteyner5 = new System.Data.DataTable();
            SqlDataAdapter MyAdapter5 = new SqlDataAdapter(MySelectCommand5);
            MyAdapter5.Fill(MyConnteyner5);
            if (MyConnteyner5.Rows.Count > 0)
            {
                foreach (DataRow MyRow5 in MyConnteyner5.Rows)
                {
                    MySheet.Cells[i, 1].Value = MyRow5["Description"];
                    MySheet.Cells[i, 1].Font.Bold = true;
                    i = i + 2;
                                       i++;
 
                    SqlConnection MyConnection1 = Connection_manager.GetCurrentConnection();
                    SqlCommand MySelectCommand1 = new SqlCommand();
                    [COLOR="red"]MySelectCommand1.CommandText = @"Update #PR1 set #PR1.qtyreleased = #PR1.qtyreleased - jobtranoper.QtyCompleteDelta
from jobtranoper
where jobtranoper.joboperationid = #PR1.joboperationid and #PR1.startdate < '2023-04-01' and jobtranoper.FactualDate < '2023-04-01' delete from #PR1 where qtyreleased = 0";
                    MySelectCommand1.CommandText = @"delete FROM #PR1 WHERE statusrus = 'Отменено' and qtycomplete = 0 and job not in,select jto.job, from JobTranOper jto where jto.job = #PR1.job and rowdate >= '2023-04-01' and rowdate <= '2023-04-30' delete from #PR1 where qtyreleased = 0";
                    MySelectCommand1.CommandText = @"select SiteWC, buhOrderDesc, sn, sum(#PR1.qtyreleased * #PR1.performersqty * #PR1.Laboriousness) as norma, 
sum(#PR1.qtyreleased * #PR1.Valuation) as summa from #PR1
group by SiteWC, sn, buhOrderDesc
Order by SiteWC, sn, buhOrderDesc";[/COLOR]
 
                    MySelectCommand1.Parameters.Add("@MyDateParam1", SqlDbType.DateTime);
                    MySelectCommand1.Parameters["@MyDateParam1"].Value = MyDateData_c.Date;
                    MySelectCommand1.Parameters.Add("@MyDateParam2", SqlDbType.DateTime);
                    MySelectCommand1.Parameters["@MyDateParam2"].Value = MyDateData_po.Date;
                    MySelectCommand1.Connection = MyConnection1;
                    MySelectCommand1.CommandTimeout = 0;
                    System.Data.DataTable MyConnteyner1 = new System.Data.DataTable();
                    SqlDataAdapter MyAdapter1 = new SqlDataAdapter(MySelectCommand1);
                    MyAdapter1.Fill(MyConnteyner1);
                    if (MyConnteyner1.Rows.Count > 0)
                    {
                        decimal summ = 0;
                        foreach (DataRow MyRow1 in MyConnteyner1.Rows)
                        {
                            MySheet.Cells[i, 1].Value = MyRow1["job"]; // job
                            MySheet.Cells[i, 2].Value = MyRow1["suffix"]; //suffix
                            MySheet.Cells[i, 3].Value = MyRow1["slcode"]; //slcode
                            MySheet.Cells[i, 4].Value = MyRow1["fullname"]; //fullname
                           [COLOR="red"] MySheet.Cells[i, 5].Value = MyRow1["SiteWC"]; //qtyreleased
                            MySheet.Cells[i, 6].Value = MyRow1["buhOrderDesc"]; //qtycomplete
                            MySheet.Cells[i, 7].Value = MyRow1["sn"]; //quantity
                            MySheet.Cells[i, 8].Value = MyRow1["summa"]; // summa[/COLOR]
                            MySheet.Cells[i, 9].Value = MyRow1["UnitMeasure"]; //unitmeasure
                                                                               //    MySheet.Cells[i, 10].Value = MyRow1[""]; 
                                                                               //  MySheet.Cells[i, 11].Value = MyRow1[""];
                                                                               //  MySheet.Cells[i, 12].Value = MyRow1[""];
                                                                               //  MySheet.Cells[i, 13].Value = MyRow1[""];
                                                                               //  MySheet.Cells[i, 14].Value = MyRow1[""];
                                                                               //  MySheet.Cells[i, 15].Value = MyRow1[""];
                            summ = summ + Convert.ToDecimal(MyRow1["summa"].ToString());
                            range = MySheet.Range[i, 1, i, 9];
                            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);
 
 
            Close();
 
        }
 
       private void ComboBox2_DropDown(object sender, EventArgs e)
        {
            //заполнение комбо-бокса Склад//
            SqlConnection MyConnection6 = Connection_manager.GetCurrentConnection();
            SqlCommand MySelectCommand6 = new SqlCommand();
            string zamena5 = comboBox2.Text.Replace("*", "%");
            MySelectCommand6.CommandText = @"select ID as whse
                                             from test2.dbo.WC
                                             where (ShortName in ('1', '2', '4', '5', '7') and WCPlot like '%000') or WCPlot = '206203' order by cast(ShortName as int)";
            MySelectCommand6.Connection = MyConnection6;
            System.Data.DataTable MyConnteyner6 = new System.Data.DataTable();
            SqlDataAdapter MyAdapter6 = new SqlDataAdapter(MySelectCommand6);
            MyAdapter6.Fill(MyConnteyner6);
            comboBox2.Items.Clear();
            foreach (DataRow MyRow6 in MyConnteyner6.Rows)
            {
                comboBox2.Items.Add(MyRow6["whse"].ToString());
            }
        }
 
 
        private void Frm_Analiz_znp_Load(object sender, EventArgs e)
        {
            var yr = DateTime.Today.Year;
            var mth = DateTime.Today.Month;
            var firstDay = new DateTime(yr, mth, 1).AddMonths(-1).AddMonths(1);
            var lastDay = new DateTime(yr, mth, 1).AddDays(0).AddMonths(1);
 
            dateTimePicker1.Value = firstDay;
            dateTimePicker2.Value = lastDay;
        }
 
        private void Button2_Click(object sender, EventArgs e)
        {
            Frm_Help MyFrm1 = new Frm_Help();
            MyFrm1.ShowDialog();
        }
 
        private void ComboBox2_SelectedIndexChanged(object sender, EventArgs e)
        {
        
        }
    }
}

   MySelectCommand5.CommandText = "CREATE TABLE #PR1 (Job bigint, Suffix smallint, StatusRus nvarchar(100), StartDate datetime, EndDate datetime, BuhOrderCode nvarchar(100), BuhOrderDesc nvarchar(100), ItemID int, SLCode nvarchar(100), FullName nvarchar(500), ItemTypesID int, SN nvarchar(100), ProcessName nvarchar(100), [Route] nvarchar(100), IsTargetItem int, JobOperationID int, QtyReleased numeric(18, 8), QtyComplete numeric(18, 8), ElemNum int, WC int, WorksAspect nvarchar(100), SiteWC nvarchar(100), [Operation] nvarchar(100), Equipment nvarchar(100), EqModelPower nvarchar(100), Payable nvarchar(100), CorrectFactor numeric(18, 8), Profession nvarchar(100), PerformersQty int, [Rank] int, Valuation numeric(18, 8), Laboriousness numeric(18, 8), HasClosedOpers int, Reason nvarchar(100)) insert into #PR1 (Job, Suffix, StatusRus, StartDate, EndDate, BuhOrderCode, BuhOrderDesc, ItemID, SLCode, FullName, ItemTypesID, SN, ProcessName, [Route], JobOperationID, QtyReleased, QtyComplete, ElemNum, WC, WorksAspect, SiteWC, [Operation], Equipment, EqModelPower, Payable, CorrectFactor, Profession, PerformersQty, [Rank], Valuation, Laboriousness, HasClosedOpers, Reason) EXECUTE dbo.GetRptPurpleTrud '2023-04-01', '2023-04-30', 207000, null";