title: Copy Distinct Records Based on 3 Cols
body: <p>I have loads of data in a table called Temp. This data consists of duplicates.
  Not Entire rows but the same data in 3 columns. They are HouseNo,DateofYear,TimeOfDay. </p>
  
  <p>I want to copy only the distinct rows from "Temp" into another table, "ThermData." </p>
  
  <p>Basically what i want to do is copy all the distinct rows from Temp to ThermData where distinct(HouseNo,DateofYear,TimeOfDay). Something like that. </p>
  
  <p>I know we can't do that. An alternative to how i can do that.</p>
  
  <p>Do help me out. I have tried lots of things but haven't solved got it.</p>
  
  <hr>
  
  <p>Sample Data. Values which are repeated are like....
  I want to delete the duplicate row based on the values of HouseNo,DateofYear,TimeOfDay</p>
  
  <hr>
  
  <pre><code>HouseNo DateofYear TimeOfDay Count
  102 10/1/2009    0:00:02 AM 2
  102 10/1/2009    1:00:02 AM 2
  102 10/1/2009    10:00:02 AM    2
  </code></pre>