Skip 'N' rows and fetch all available
<p>I have a simple requirement i want to skip 'N' rows and fetch all avaialbe. I need this as a part of my stored procedure something like<BR></p>

<pre><code> WHERE /*some condition*/   
 ORDER BY 
        /* some case statement */    
OFFSET @SkipRows ROWS FETCH NEXT @TakeRows ROWS ONLY
</code></pre>

<p>now my requirement is if @TakeRows is some value say -1 i wanted to fetch all rows. I am trying to avoid an extra call to calculate row count</p>