title: SELECT DISTINCT
body: <p>I'm working on an SSIS package where I'm importing data from a CSV file into a SQL table.</p>
  
  <p>The only field that I'm concern with is the Username. This Username must be <strong><em>unique</em></strong>. I don't care whether first name or last name are the same or not.</p>
  
  <p>In the package, I imported the data from file into a temp SQL table. And then I used SELECT DISTINCT to pick unique Username. And then insert into the destination table.</p>
  
  <p>The problem is: When I do a SELECT DISTINCT Username, Firstname and Lastname FROM tempUsers.</p>
  
  <p>It returns:</p>
  
  <ul>
  <li>JSmith, John, Smith</li>
  <li>JSmith, Joe, Smart</li>
  <li>MBopp, Mary, Boppins</li>
  </ul>
  
  <p>But I want it to return:</p>
  
  <ul>
  <li>JSmith, John, Smith</li>
  <li>MBopp, Mary, Boppins</li>
  </ul>