27,579
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([日期] Date,[客户编号] nvarchar(26),[金额] decimal(18,14),[数量] decimal(18,14))
Insert #T
select '2017-07-08',N'010294',91.00000000,7.00000000 union all
select '2017-08-01',N'010294',42.00000000,2.00000000 union all
select '2017-08-28',N'010001',3078.00000000,180.00000000 union all
select '2017-07-28',N'010001',615.6,36.00000000
Go
--测试数据结束
SELECT
a.客户编号,
a.金额 AS [7月销售额],
a.数量 AS [7月数量],
b.金额 AS [8月销售额],
b.数量 AS [8月数量],
b.金额 - a.金额 AS 差额
FROM
#T a
JOIN
#T b
ON b.客户编号 = a.客户编号
AND DATEDIFF(MONTH, '2017-07-01', a.日期) = 0
AND DATEDIFF(MONTH, '2017-08-01', b.日期) = 0;