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, Fabric, enterprise Power BI, SQL Server BI, Data Modeling, SSAS Design, SSRS, Dashboards & Visualization since 2009
There are certain key words in a T-SQL query than cannot be parameterized, including the TOP statement.