title: Dynamic Order by SELECT with multiple columns
body: <p>What is the correct MS SQL syntax to select multiple ORDER BY columns when the ORDER BY is based on a CASE statement? </p>
  
  <p>The below works fine with single columns, but I need to sort by multiple columns:</p>
  
  <pre><code>SELECT * FROM Products
  ORDER BY 
  CASE WHEN @SortIndex = 1 THEN Price END ASC,
  CASE WHEN @SortIndex = 2 THEN Price DESC, Title ASC END &lt;-- problem line
  </code></pre>