select wzxz as wzxz, count(*) as gs
INTO #tmp from cbs where jsdw='环卫' and xmmc='环卫' group by wzxz
select wzxz as wzxz, count(*) as gs
INTO #tmp from cbs where jsdw='供热站' and xmmc='供热' group by wzxz查询出多个结果想同时插入一个临时表中
if object_id('tempdb.dbo.#tmp') is not null Begin drop table #tmp End
select wzxz as wzxz, count(*) as gs
INTO #tmp from cbs where jsdw='环卫' and xmmc='环卫' group by wzxz
select * from #tmp
目前只能插一条 然后删掉临时表再插入一条想声场这样一个临时表(多条数据同时插入 生成一个有多条数据的表)
类型 个数
类型1 2
类型2 3
INTO #tmp from cbs where jsdw='环卫' and xmmc='环卫' group by wzxz
select wzxz as wzxz, count(*) as gs
INTO #tmp from cbs where jsdw='供热站' and xmmc='供热' group by wzxz查询出多个结果想同时插入一个临时表中
if object_id('tempdb.dbo.#tmp') is not null Begin drop table #tmp End
select wzxz as wzxz, count(*) as gs
INTO #tmp from cbs where jsdw='环卫' and xmmc='环卫' group by wzxz
select * from #tmp
目前只能插一条 然后删掉临时表再插入一条想声场这样一个临时表(多条数据同时插入 生成一个有多条数据的表)
类型 个数
类型1 2
类型2 3
INTO #tmp from cbs group by wzxz,jsdw,xmmc
然后用insert into #tmp select a,b from tb where xxx的形式插入你要的数据
INTO #tmp
FROM ( SELECT wzxz AS wzxz ,
COUNT(*) AS gs
FROM cbs
WHERE jsdw = '环卫'
AND xmmc = '环卫'
GROUP BY wzxz
UNION ALL
SELECT wzxz AS wzxz ,
COUNT(*) AS gs
FROM cbs
WHERE jsdw = '供热站'
AND xmmc = '供热'
GROUP BY wzxz
) a
INTO #tmp
FROM ( SELECT wzxz AS wzxz ,
COUNT(*) AS gs
FROM cbs
WHERE jsdw = '环卫'
AND xmmc = '环卫' and 你需要筛选的条件
GROUP BY wzxz
UNION ALL
SELECT wzxz AS wzxz ,
COUNT(*) AS gs
FROM cbs
WHERE jsdw = '供热站'
AND xmmc = '供热' and 你需要筛选的条件
GROUP BY wzxz
) a