title: Need multiple copies of one resultset in sql without using loop
body: <p>Following is the sample data. I need to make 3 copies of this data in t sql without using loop and return as one resultset. This is sample data not real.</p>
  
  <pre><code>42  South Yorkshire
  43  Lancashire
  44  Norfolk
  </code></pre>
  
  <p>Edit: I need multiple copies and I have no idea in advance that how many copies I need I have to decide this on the basis of dates. Date might be 1st jan to 3rd Jan OR 1st jan to 8th Jan.</p>
  
  <p>Thanks.</p>