title: Table partitioning using 2 columns
body: <p>Is it possible to partition a table using 2 columns instead of only 1 for the partition function?</p>
  
  <p>Consider a table with 3 columns </p>
  
  <pre>
      ID (int, primary key, 
      Date (datetime), 
      Num (int)
  </pre>
  
  <p>I want to partition this table by 2 columns: <code>Date</code> and <code>Num</code>. </p>
  
  <p>This is what I do to partition a table using 1 column (date):</p>
  
  <pre><code>create PARTITION FUNCTION PFN_MonthRange (datetime)
  AS
  RANGE left FOR VALUES ('2009-11-30 23:59:59:997',
                         '2009-12-31 23:59:59:997',
                         '2010-01-31 23:59:59:997',
                         '2010-28-02 23:59:59:997',
                         '2010-03-31 23:59:59:997')
  go
  </code></pre>