怎么实现这个SQL问题?

create table #asset(times varchar(10),number int)
insert #asset
select '2006-1',5 union all
select '2006-2',10 union all
select '2006-5',8 union all
select '2006-8',16 union all
select '2006-12',9

select top 12 mon=identity(int,1,1) into #mon from syscolumns

select times='2006-'+ltrim(a.mon),number=isnull(b.number,0) from #mon a left join #asset b on '2006-'+ltrim(a.mon)=b.times

drop table #mon,#asset

版主厉害呀....
不说了,啥都不说了....
谢谢啊.....

就是论坛的登录密码...

我晕....