在SQL Server存储过程的SELECT UNION中返回许多行

I have the following stored procedure that returns a large number of rows. I want to limit the number of rows to 50. How can I do that in a I have the following stored procedure that retu