sqlserver 将union查询写入新表

最新推荐文章于 2023-04-14 16:59:36 发布

Fergus awsl

最新推荐文章于 2023-04-14 16:59:36 发布

阅读量2.6k

点赞数

分类专栏： SQL

本文链接：https://blog.csdn.net/weixin_43650411/article/details/95364657

版权

SQL 专栏收录该内容

71 篇文章 0 订阅

订阅专栏

-- 写入临时表
select * into #temp

-- 写入新表
use Report
go
if exists(select name from sys.objects where name='消费_月')
	drop table 消费_月
go
use [Account Management]
go
select t.* into Report.dbo.消费_月 from 
(
	(select 月度='201901', 用户名, 类别, sum(金额) sum_of_month from 消费 where 日期 between '20190101' and '20190131'
	group by 用户名, 类别)
	union all
	(select 月度='201902', 用户名, 类别, sum(金额) sum_of_month from 消费 where 日期 between '20190201' and '20190228'
	group by 用户名, 类别)
	union all
	(select 月度='201903', 用户名, 类别, sum(金额) sum_of_month from 消费 where 日期 between '20190301' and '20190331'
	group by 用户名, 类别)
	union all
	(select 月度='201904', 用户名, 类别, sum(金额) sum_of_month from 消费 where 日期 between '20190401' and '20190430'
	group by 用户名, 类别)
	union all
	(select 月度='201905', 用户名, 类别, sum(金额) sum_of_month from 消费 where 日期 between '20190501' and '20190531'
	group by 用户名, 类别)
	union all
	(select 月度='201906', 用户名, 类别, sum(金额) sum_of_month from 消费 where 日期 between '20190601' and '20190630'
	group by 用户名, 类别)
) t