出于某种原因，我的存储过程什么也没有返回

I am creating a stored procedure that returns data from many tables, so it has several chunks to it that finally result in one temp table. The only issue is it is not producing anything. All of the separate chunks seem to work, but as a whole it doesn't.I am creating a stored procedure that returns d