无法用系统临时表只能改为数据表，然后查询结束后再删除

  if exists( 
     select  
         exp_count 
     from 
         tbl_expend 
     where  
         exp_valid = 1 and exp_public = 0 and exp_monthly = 0 and  convert(varchar(7),exp_date,120) = convert(varchar(7),cast('2020/04/03 22:57:20'as datetime ),120)   
 ) 
     begin 
         select  
             exp_count,exp_price,exp_public,exp_date,exp_item,exp_valid,exp_monthly,exp_record,exp_type,exp_level 
         into temp1 
         from 
             tbl_expend 
         where  
             exp_valid = 1 and exp_public = 0 and exp_monthly = 0 and  convert(varchar(7),exp_date,120) = convert(varchar(7),cast('2020/04/03 22:57:20'as datetime ),120)   
     end 
 else 
     begin 
         select 0 as exp_count,0 as exp_price,0 as exp_public,getdate() as exp_date,'' as exp_item  ,1 as exp_valid,0 as exp_monthly,0 as exp_record,'' as exp_type,0 as exp_level into temp1 
     end 
 go  

  select   
     convert(varchar(7),cast('2020/04/03 22:57:20'as datetime ),120) as 月份,  
     isnull(count(isnull(exp_item,0)),0) as 消费计数,      isnull(sum(isnull(exp_price,0)*isnull(exp_count,0)),0) as 花费金额  
     ,isnull(inc_amount,0) as 收款金额,      (isnull(inc_amount,0)-isnull(sum(isnull(exp_price,0)*isnull(exp_count,0)),0)) as 余额  
 from   
     temp1 a  left join ( 
             select                
                 sum(isnull(inc_amount,0)) as inc_amount           
             from               tbl_income            
             where  
                 convert(varchar(7),inc_date,120) = convert(varchar(7),cast('2020/04/03 22:57:20'as datetime ),120)  
                 and inc_valid = 1 and inc_monthly = 0  and inc_public = 0     ) b on 1 = 1   
 where        

     exp_valid = 1 and exp_monthly = 0  and exp_public = 0    
     and convert(varchar(7),exp_date,120) = convert(varchar(7),cast('2020/04/03 22:57:20'as datetime ),120)       
 group by    
     convert(varchar(7),exp_date,111),inc_amount  

 go 

select * from temp1

go

drop table temp1