title: SQL Server SQL Select: How do I select rows where sum of a column is within a specified multiple?
body: <p>I have a process that needs to select rows from a Table (queued items) each row has a quantity column and I need to select rows where the quantities add to a specific multiple. The mulitple is the order of between around 4, 8, 10 (but could in theory be any multiple. (odd or even)</p>
  
  <p>Any suggestions on how to select rows where the sum of a field is of a specified multiple?</p>