DECLARE @SQLString varchar(8000)
SET @SQLString = 'select EnterpriseEmployeeID,case when grouping(员工姓名)=1 then ''小计'' else 员工姓名 end as 员工姓名'
SELECT @SQLString = @SQLString + ',' + 客户状态 + '=sum(case 客户状态 when ''' +
客户状态 + ''' then 1 else 0 end)'
FROM CustomerStatus
SET @SQLString = @SQLString + 'from CustomerInformation where 上司 = 2 group by EnterpriseEmployeeID,员工姓名 with rollup having grouping(EnterpriseEmployeeID)+grouping(员工姓名)<>1'
EXEC (@SQLString)
SET @SQLString = 'select EnterpriseEmployeeID,case when grouping(员工姓名)=1 then ''小计'' else 员工姓名 end as 员工姓名'
SELECT @SQLString = @SQLString + ',' + 客户状态 + '=sum(case 客户状态 when ''' +
客户状态 + ''' then 1 else 0 end)'
FROM CustomerStatus
SET @SQLString = @SQLString + 'from CustomerInformation where 上司 = 2 group by EnterpriseEmployeeID,员工姓名 with rollup having grouping(EnterpriseEmployeeID)+grouping(员工姓名)<>1'
EXEC (@SQLString)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货