Select TOP @N where @N is a variable from another Query

Question

I am building a report on server hardware projections, and I'm getting stuck here.

I have a query that correctly returns the number of HDD's installed on the server, and am storing that number into a variable called @OtherHDDs, and it is an INT.

I need to now do this...

Select top @OtherHDDs.... 
from ...

How do I do this correctly?

Answer 1

You need to enclose the variable in parenthesis:

select top (@OtherHDDs) -- your column list here
from YourTable

MSDN Reference on SELECT