错在哪,为什么没数据?救火啊

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
alter      procedure P_Stock_23 (
    @Year char(4)
    ) as        DECLARE @ReportType varchar(10)
        DECLARE @YesYear int
   SET @YesYear = CAST(@Year as int) - 1
   SET  @ReportType='B-23'  --'财务顾问-交易数量'
BEGIN TRAN tSetdelete Total_Year_Common where Total_Year_Common.Year = @Year and ReportType = @ReportType

  drop table #Result_Amount

  drop table #Result_Account

drop table #Result_Amount_YesYear

  drop table #Result_Account_YesYearcreate table #Result_Amount
(       Oid   int identity(1,1),
    --TotalItem   int identity(1,1),
ReportType varchar(10) ,
Year    char(4) ,
[name] varchar(500) ,
tradecount float,
--trademoney float
)

create table #Result_Account
(       Oid   int identity(1,1),
--TotalItem   int identity(1,1),
ReportType varchar(10) ,
Year    char(4) ,
[name] varchar(500) ,
--tradecount int,
trademoney float
)
create table #Result_Amount_YesYear
(         --TotalItem   int identity(1,1),
ReportType varchar(10) ,
Year    char(4) ,
[name] varchar(500) ,
tradecount float,
--trademoney float 
 Oid   int identity(1,1)
)

create table #Result_Account_YesYear
(       Oid   int identity(1,1),
--TotalItem   int identity(1,1),
ReportType varchar(10) ,
Year    char(4) ,
[name] varchar(500) ,
--tradecount int,
trademoney float
)



insert into #Result_Amount_YesYear select top 10 @ReportType,@YesYear,F_Financing,count(TradeID)--, sum(TradeMoney)
from ##V_Trade_Main_Intermediaries_Stock   where year(DateInure)=Cast(@YesYear as int) Group by F_Financing
insert into #Result_Amount select top 10 @ReportType,@Year,F_Financing,count(TradeID)--, sum(TradeMoney)
from ##V_Trade_Main_Intermediaries_Stock   where year(DateInure)=Cast(@Year as int) Group by F_Financing



insert into #Result_Account_YesYear select top 10 @ReportType,@YesYear,F_Financing,--count(TradeID),
sum(TradeMoney)
from ##V_Trade_Main_Intermediaries_Stock   where year(DateInure)=Cast(@YesYear as int) Group by F_Financing
insert into #Result_Account select top 10 @ReportType,@Year,F_Financing,--count(TradeID)--, 
sum(TradeMoney)
from ##V_Trade_Main_Intermediaries_Stock   where year(DateInure)=Cast(@Year as int) Group by F_Financing insert into Total_Year_Common (ReportType,Year,Ord,TotalItem,BeforeAmount,AfterAmount) select b.ReportType,b.Year,b.Oid,b.Oid,a.tradecount,b.tradecount   from #Result_Amount b,#Result_Amount_YesYear a  where  b.ReportType=@ReportType  and  a.ReportType=b.ReportType  and b.Year= @Yearinsert into Total_Year_Common (ReportType,Year,Ord,TotalItem,BeforeMoney,AfterMoney) select d.ReportType,d.Year,d.Oid,d.Oid,c.trademoney,d.trademoney   from #Result_Account d, #Result_Account_YesYear c where  d.ReportType=@ReportType    and  c.ReportType=d.ReportType  and d.Year=@YearCOMMIT TRAN tSet
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO