本文介绍了一种使用T表进行数据插入的方法，并通过多个表之间的联结查询来获取汇总信息。具体包括如何创建临时表、插入数据及执行跨表查询等关键步骤。
declare @t table(id int,name varchar(20),bh int)
insert into @t
select 1,'aa',10
union all select 2,'bb',11
select name=a.name,bh=b.bh,sl=isnull(c.sl,0)from
(select name from @t group by name) a
cross join
(select bh from @t group by bh) b
left join
(select name,bh,sl=count(*) from @t group by name,bh) c
on a.name=c.name and b.bh=c.bh
insert into @t
select 1,'aa',10
union all select 2,'bb',11
select name=a.name,bh=b.bh,sl=isnull(c.sl,0)from
(select name from @t group by name) a
cross join
(select bh from @t group by bh) b
left join
(select name,bh,sl=count(*) from @t group by name,bh) c
on a.name=c.name and b.bh=c.bh
扫一扫
4069
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
