title: How to insert artificial data into a select statement
body: <p>Suppose we got a original query as follows:</p>
  
  <pre><code>SELECT A, B, C FROM tblA
  </code></pre>
  
  <p>Now, I need to additional artificial rows like 
  <strong>SELECT 'Kyala', B, C FROM tblA</strong> when, for example, C = 100 to be inserted into the resultset. </p>
  
  <p>As an example, if the tblA hold one row:</p>
  
  <pre><code>A      B      C
  John   1      100
  </code></pre>
  
  <p>my goal is to return two rows like below with a single SQL query.</p>
  
  <pre><code>A      B      C
  John   1      100
  Kyala  1      100
  </code></pre>
  
  <p>How could I achieve it <strong>using a single SQL</strong> instead of relying on table variable or temp table?</p>