How to parameterize a TOP values query
There are certain key words in a T-SQL query than cannot be parameterized, including the TOP statement.
Paul Turley's SQL Server BI Blog
sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009
There are certain key words in a T-SQL query than cannot be parameterized, including the TOP statement.