存储过程中创建临时表，以致没有返回结果集！_Sql Server

存储过程中创建临时表，导致没有返回结果集！！
现在遇见一个很奇怪的问题，
直接上代码：
SET NOCOUNT on  
USE [SOA_DEV]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

                                                                                              
alter proc [dbo].[sk_taobao_xsspty_lgr_test]                                                                                          
@djlx varchar(3),                                                                                          
@gzid varchar(11)=null,                                                                                          
@v_zjm varchar(40)=null,                                                                                             
@xgdjbh varchar(15)=null,                                                                                          
@dwbh varchar(11)=null,                                                                                          
@start_rq varchar(10)=null,                                                                                          
@end_rq varchar(10)=null,                                                                              
@spbh varchar(50)=null,                                                                                             
@is_sfyp varchar(2)=null