-- I hope this demonstrates a relatively simple method

declare @id1 int

create table #result (id1 int)

set @sql = 'SELECT MAX(ID1) FROM (SELECT TOP '+ CAST(@grade1 as varchar)+ ' * FROM...