存储过程查不出数据

[zhuxuejian_R]

使用存储过程，根据条件查询一张table_a表的数据，然后插入到临时表#MxTemp，再返回
我调试好多次了，就是不成功

if @rpt_type = '01'
		begin
				insert into   #MxTemp(card_id,merchant_id,wz_id,dept_id,czry_id,machine_id,cardtype_id,iccardtype_id,cardhard_id,[user_name]
				,user_xb,user_address,user_tel,user_password,user_company,zjbh,zjlx,school,nj,sktime,sendbz,hztime,inputfilename
				,operate_id,outpc,ybz1,ylbz2)
				select        card_id,merchant_id,wz_id,dept_id,czry_id,machine_id,cardtype_id,iccardtype_id,cardhard_id,[user_name]
				,user_xb,user_address,user_tel,user_password,user_company,zjbh,zjlx,school,nj,sktime,sendbz,hztime,inputfilename
				,operate_id,outpc,ylbz1,ylbz2
				from		  table_a
				where		    cardhard_id like '%'+ @cardhard_id +'%' 
				and iccardtype_id like '%'+ @iccardtype_id +'%' and
							  [user_name] like '%'+ @user_name +'%' and cardtype_id like '%'+ @cardtype_id +'%'and
								sktime >= @qsrq and @zzrq >= sktime
				begin
					select * from #MxTemp
				end 
		end

大神帮忙看看哪错了，谢谢！

[快溜]

if @rpt_type = '01' begin insert into #MxTemp(card_id,merchant_id,wz_id,dept_id,czry_id,machine_id,cardtype_id,iccardtype_id,cardhard_id,[user_name] ,user_xb,user_address,user_tel,user_password,user_company,zjbh,zjlx,school,nj,sktime,sendbz,hztime,inputfilename ,operate_id,outpc,ybz1,ylbz2) select card_id,merchant_id,wz_id,dept_id,czry_id,machine_id,cardtype_id,iccardtype_id,cardhard_id,[user_name] ,user_xb,user_address,user_tel,user_password,user_company,zjbh,zjlx,school,nj,sktime,sendbz,hztime,inputfilename ,operate_id,outpc,ylbz1,ylbz2 from table_a where cardhard_id like '%'+ @cardhard_id +'%' and iccardtype_id like '%'+ @iccardtype_id +'%' and [user_name] like '%'+ @user_name +'%' and cardtype_id like '%'+ @cardtype_id +'%'and sktime >= @qsrq and @zzrq >= sktime end select * from #MxTemp

[kingtiy]

看下报错信息是啥来的.