你发了两贴~~
IF OBJECT_ID('Tempdb..#t') IS NOT NULL DROP TABLE #t
BEGIN
SELECT
CustomerType, 'm' + CAST(DATE_FORMAT(Create_date,'%c')AS VARCHAR(2)) mm, count(id) tNum INTO #t
FROM
dbo.CRM_Customer
WHERE
DATE_FORMAT(Create_date,'%Y')=2014
GROUP BY CustomerType, 'm' + CAST(DATE_FORMAT(Create_date,'%c')AS VARCHAR(2))
DECLARE @sql varchar(8000)
SET
@sql = 'select CustomerType items '
SELECT
@sql = @sql + ',sum(case mm when ' + char(39) + mm + char(39) + ' then tNum else 0 end) [' + mm + ']'
FROM
(SELECT DISTINCT mm FROM #t) AS data
SET @sql = @sql + ' from #t group by CustomerType'
EXEC (@sql)
END
IF OBJECT_ID('Tempdb..#t') IS NOT NULL DROP TABLE #t
BEGIN
SELECT
CustomerType, 'm' + CAST(DATE_FORMAT(Create_date,'%c')AS VARCHAR(2)) mm, count(id) tNum INTO #t
FROM
dbo.CRM_Customer
WHERE
DATE_FORMAT(Create_date,'%Y')=2014
GROUP BY CustomerType, 'm' + CAST(DATE_FORMAT(Create_date,'%c')AS VARCHAR(2))
DECLARE @sql varchar(8000)
SET
@sql = 'select CustomerType items '
SELECT
@sql = @sql + ',sum(case mm when ' + char(39) + mm + char(39) + ' then tNum else 0 end) [' + mm + ']'
FROM
(SELECT DISTINCT mm FROM #t) AS data
SET @sql = @sql + ' from #t group by CustomerType'
EXEC (@sql)
END
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货