title: non sequential SQL partitioning
body: <blockquote>
    <p>Blockquote</p>
  </blockquote>
  
  <p>All,</p>
  
  <p>I am trying to partition a set of data but I don't want my partitions to be "sequential". </p>
  
  <p>Traditionally by partitioning by ID and then by sale stage I get this. Sequential partitioning.</p>
  
  <pre><code>ROW_NUMBER() OVER(PARTITION BY  ID,  sale stage ORDER BY  Converge, modified date desc)
  
  ID               sale stage      modified date      partition
  01_AAI_73133    Closed Lost        5/1/2015             1
  01_AAI_73133    Closed Lost        4/26/2015            2
  01_AAI_73133    Closed Lost        4/20/2015            3
  01_AAI_73133    Locked and Loaded  4/5/2015             1
  01_AAI_73133    Locked and Loaded  3/29/2015            2
  01_AAI_73133    Pitching           3/7/2015             1
  01_AAI_73133    Pitching           2/14/2015            2
  01_AAI_73133    Pitching           2/1/2015             3
  01_AAI_73134    Pitching           1/20/2015            4
  </code></pre>
  
  <p>What I actually want is this</p>
  
  <pre><code>ID               sale stage      modified date      partition
  01_AAI_73133    Closed Lost        5/1/2015             1
  01_AAI_73133    Closed Lost        4/26/2015            1
  01_AAI_73133    Closed Lost        4/20/2015            1
  01_AAI_73133    Locked and Loaded  4/5/2015             2
  01_AAI_73133    Locked and Loaded  3/29/2015            2
  01_AAI_73133    Pitching           3/7/2015             3
  01_AAI_73133    Pitching           2/14/2015            3
  01_AAI_73133    Pitching           2/1/2015             3
  01_AAI_73134    Pitching           1/20/2015            3
  </code></pre>
  
  <p>Does anyone have a idea how to achieve this?</p>
  
  <p>Thanks</p>