title: How to insert data into temp table from a string
body: <p>I have one table as the following</p>
  
  <p>Business (BId - BName)</p>
  
  <ul>
  <li><p>1 - ABC</p></li>
  <li><p>2 - DEF</p></li>
  <li><p>3 - GHI</p></li>
  <li><p>4 - JKL</p></li>
  </ul>
  
  <p>And I created a temporary table </p>
  
  <pre><code>Create table #Temp(
  TBID int,
  TBNAME nvarchar(50)
  );
  </code></pre>
  
  <p>Now I have to add the data into #temp from a string like </p>
  
  <pre><code>Declare string = 'ABC, GHI'
  </code></pre>
  
  <p>How will I add data into #temp table from the above string with its corresponding Ids in #temp</p>
  
  <p>The output of the table #temp should be like </p>
  
  <p>#temp (TBID - TBNAME</p>
  
  <ul>
  <li><p>1 - ABC</p></li>
  <li><p>3 - GHI</p></li>
  </ul>