sql 定义临时表

        declare @year int=year(getdate())
declare @month int=month(getdate())

declare @myYearTable table(year_target int) 
begin
insert into @myYearTable(year_target) values(@year)
insert into @myYearTable(year_target) values(@year-1)
end

select 
my.year_target 
,ROUND(yt.parts_year_sale_number,0) as parts_year_sale_money_target
,ROUND(a.parts_month_sale_number,0) as parts_year_sale_money
from
@myYearTable my 
left join year_Target yt on yt.year_target = my.year_target and yt.company_id=@companyId    
order by year_target asc