title: SQL query results Need to Return all records in WHERE clause even duplicates
body: <p>I am new to Microsoft SQL Server and need a query to return all records listed in the WHERE clause even duplicates.  What I have will only return 3 rows.</p>
  
  <p>I am reading in and parsing a text file using c#. And with that text file I am creating a query to get results from a database and then using the results to rebuild that text file. The original text file contains duplicate rows. Each row needs to be associated to the data retrieved from the database. – </p>
  
  <pre><code>SELECT tbl1.HdrCode, tbl1.HdrName
  FROM Table1 tbl1
  WHERE tbl1.HdrCode 
  IN ('000520',
  '000531',
  '000531',
  '000636')
  </code></pre>
  
  <p>What I need returned is :</p>
  
  <pre><code>000520  Name1
  000531  Name2
  000531  Name2  
  000636  Name3   
  </code></pre>
  
  <p>Thanks             </p>