SP for getting the Nth highest value of a column

Create procedure dbo.NthHighest
(
@Number integer,
@FieldNamevarchar(100),
@TableNamevarchar(100)
)
as
declare @SQL varchar(1000)

set @SQL = 'select min(' + @FieldName + ')'
set @SQL = @SQL + ' from ' + @TableName
set @SQL = @SQL + ' where ' + @FieldName
set @SQL = @SQL + 'in ( select top ' + convert(varchar, @Number) + ' ' + @FieldName
set @SQL = @SQL + 'from ' + @TableName
set @SQL = @SQL + 'where ' + @FieldName + ' < ( select max(' + @FieldName
set @SQL = @SQL + ' ) from ' + @TableName + ') '
set @SQL = @SQL + 'order by ' + @FieldName + ' desc )'

exec (@SQL)