title: Adding multiple values to a table
body: <p>I need to add multiple values to a table which are taken from other table or calculated using other tables. I am using a code as shown below. Please tell how can we calculate the values which are fetched from other table. I need to insert to a table sales(scriptname,accnum,sharesbought,sharessold,remshares) from the table transac(tid,sciptname,accnum,transactype,Quantity,date). Based on the transac type I need to find whether it is sharebought or sharesold and remainingshare is sharebought-sharesold;</p>
  
  <p>I am using .Net to do this please tell me that whether the code I am using it is correct or not.</p>
  
  <pre><code>    SqlConnection Con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
                  Con.Open();
                  string insertsale = "INSERT INTO sales s (accnum, scriptname, shares_bought,sharessold,rem_shares) select case when t.transactype == 'sell' then s.accnum = t.accnum, s.scriptname = t.scriptname. s.shares_bought = 0,s.shares_sold=t.quanity, (s.shares_bought-s.shares_sold) as s.rem_shares 
  else
   s.accnum = t.accnum, s.scriptname = t.scriptname. s.shares_bought = t.quanity,s.shares_sold=0, (s.shares_bought-s.shares_sold) as s.rem_shares from transac t";
                  SqlCommand cmd = new SqlCommand(insertsale, Con);
                  cmd.ExecuteNonQuery();
                  Con.Close();
  </code></pre>