title: What is the best way to retrieve distinct / unique values using SPQuery?
body: <p>I have a list that looks like:</p>
  
  <pre><code>Movie          Year
  -----          ----
  Fight Club     1999
  The Matrix     1999
  Pulp Fiction   1994
  </code></pre>
  
  <p>Using CAML and the SPQuery object I need to get a distinct list of items from the Year column which will populate a drop down control.</p>
  
  <p>Searching around there doesn't appear to be a way of doing this within the CAML query. I'm wondering how people have gone about achieving this?</p>