title: Is there a way to coalesce the top option value in stored procedure?
body: <p>is there a way to say if a @topParam value is passed in use that, if not select all.</p>
  
  <pre><code>@topParam
  select TOP COALESCE ( @topParam, all )
  </code></pre>