title: How can I select from list of values in SQL Server
body: <p>I have very simple problem that I can't solve. I need to do something like this:</p>
  
  <pre><code>select distinct * from (1, 1, 1, 2, 5, 1, 6).
  </code></pre>
  
  <p>Anybody can help??</p>
  
  <p><strong>Edit</strong> </p>
  
  <p>The data comes as a text file from one of our clients. It's totally unformatted (it's a single, very long line of text), but it may be possible to do so in Excel. But it's not practical for me, because I will need to use these values in my sql query. It's not convenient to do so every time I need to run a query.</p>