shinger@126.comset nocount on
declare @DateType int --日期维度 1表示年月,2表示年月日
set @DateType=2
if OBJECT_ID(\'tempdb..#Rep\') is not null drop table #Rep
create table #Rep(CustName nvarchar(20),SaleDate date,SalesAmount money)
insert into #Rep(CustName,SaleDate,SalesAmount)
select N\'张三\',\'2022-03-01\',100
union all
select N\'张三\',\'2022-03-03\',120
union all
select N\'李四\',\'2022-03-05\',80
if @DateType=1
begin
select CustName,convert(varchar(7),SaleDate,120) SaleDate,sum(SalesAmount) SalesAmount
from #Rep
group by CustName,convert(varchar(7),SaleDate,120)
end
else
begin
select CustName,SaleDate,sum(SalesAmount) SalesAmount
from #Rep
group by CustName,SaleDate
end
直接用参数控制返回的结果,不依赖帆软报表的公式