Year Quarter Amount
---- ------- ------
1990 1 1.1
1990 2 1.2
1991 1 2.1
1991 2 2.2SELECT Year,
SUM(CASE Quarter WHEN 1 THEN Amount ELSE 0 END) AS Q1,
SUM(CASE Quarter WHEN 2 THEN Amount ELSE 0 END) AS Q2
FROM Northwind.dbo.Pivot
GROUP BY Year以上是联机丛书中的例子,我有类似的表,想建一个view实现交叉报表,select语句运行正常,但在view中保存时报错,不知是怎么回事?
---- ------- ------
1990 1 1.1
1990 2 1.2
1991 1 2.1
1991 2 2.2SELECT Year,
SUM(CASE Quarter WHEN 1 THEN Amount ELSE 0 END) AS Q1,
SUM(CASE Quarter WHEN 2 THEN Amount ELSE 0 END) AS Q2
FROM Northwind.dbo.Pivot
GROUP BY Year以上是联机丛书中的例子,我有类似的表,想建一个view实现交叉报表,select语句运行正常,但在view中保存时报错,不知是怎么回事?
---- ------- ------
1990 1 1.1
1990 2 1.2
1991 1 2.1
1991 2 2.2SELECT Year,
SUM(CASE Quarter WHEN 1 THEN Amount ELSE 0 END) AS Q1,
SUM(CASE Quarter WHEN 2 THEN Amount ELSE 0 END) AS Q2
FROM Northwind.dbo.Pivot
GROUP BY Year以上是联机丛书中的例子,我有类似的表,想建一个view实现交叉报表,select语句运行正常,但在view中保存时报错,不知是怎么回事?