extract top 10 from results without modifying the actual query

Question

I have a dynamic query, and i am using exec command in stored procedure to execute it.

now i want to extract only Top 10 rows from result of executed query.

i can't modify the query, i want to extract from the result only

This is the query i am executing.

 DECLARE @Str nvarchar(max)
 SET @str = 'SELECT *
      FROM tblC6FD_QueryBuilderMaster'

 EXEC (@str)

how can i limit the results without modify the actually query

Thanks

Answer 1

Use ROWCOUNT:

DECLARE @Str nvarchar(max)
SET @str = 'SELECT * FROM tblC6FD_QueryBuilderMaster'

SET ROWCOUNT 10
EXEC (@str)
SET ROWCOUNT 0