title: Use variable with TOP in select statement in SQL Server without making it dynamic
body: <pre><code>declare @top  int
  set @top = 5
  select top @top * from tablename
  </code></pre>
  
  <p>Is it possible?</p>
  
  <p>Or any idea for such a logic (i don't want to use dynamic query)?</p>