SELECT @sSQL = '',@sCol = ''
SET @sSQL = 'SELECT CircleClass AS Code,CircleClass AS ''周期''' + CHAR(13) + CHAR(10)
WHILE EXISTS(SELECT * FROM @tClass)
BEGIN
SELECT @sCol = [ClassName] FROM @tClass ORDER BY [id] DESC
DELETE FROM @tClass WHERE [ClassName] = @sCol
SET @sSQL = @sSQL + ' ,SUM(CASE ProductClass WHEN ''' + RTRIM(@sCol) + ''' THEN ''Quantity'' ELSE 0 END)
AS ''' + RTRIM(@sCol) + '''' + CHAR(13) + CHAR(10)
END
SET @sSQL = @sSQL + 'FROM #tRes' + CHAR(13) + CHAR(10)
SET @sSQL = @sSQL + 'GROUP BY CircleClass' + CHAR(13) + CHAR(10)
EXEC(@sSQL)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货