title: can we use CASE with EXEC
body: <p>I want to select a stored proc to execute based on user input. Something like -</p>
  
  <pre><code>EXEC
  CASE @InputParam 
    WHEN 'XML' THEN GetXMLData @ID, 'y'
    WHEN 'TABLE' THEN GetTableData @ID, 'y'
  END
  </code></pre>
  
  <p>Can this be done with <code>CASE</code> or should I consider using the <code>If</code> construct?</p>