视图无法运行在GroupBy中出现一些问题 [英] Views Unable to Run Occur some problem in GroupBy

问题描述

我已经用五个表制作了一个视图，在这个视图中，我正在使用Group by子句，并且出现了下面的问题

Hi,

I have made one view with five tables and in this view i am using Group by clause and it is giving problem like below

CREATE VIEW Title_Performance
AS
SELECT USCATVLS_1, ITMCLSCD, SALSTERR, SUM(EXTENDEDPRICE) AS EXTENDEDPRICE, SUM(EXTENDEDCOST) AS EXTENDEDCOST, SUM(Margin) 
                      AS Margin
FROM         (SELECT dbo.IV00101.USCATVLS_1, dbo.IV00101.ITMCLSCD, dbo.RM00101.SALSTERR, SUM(CASE SOP30300.SOPTYPE WHEN 4 THEN (- 1) 
                                              * (SOP30300.XTNDPRCE) ELSE SOP30300.XTNDPRCE END) AS EXTENDEDPRICE, SUM(CASE SOP30300.SOPTYPE WHEN 4 THEN (- 1) 
                                              * (SOP30300.EXTDCOST) ELSE SOP30300.EXTDCOST END) AS EXTENDEDCOST, SUM(CASE SOP30300.SOPTYPE WHEN 4 THEN (- 1) 
                                              * (SOP30300.XTNDPRCE) ELSE SOP30300.XTNDPRCE END) - SUM(CASE SOP30300.SOPTYPE WHEN 4 THEN (- 1) * (SOP30300.EXTDCOST) 
                                              ELSE SOP30300.EXTDCOST END) AS Margin, dbo.IV40600.UserCatLongDescr
                       FROM          dbo.SOP30300 INNER JOIN
                                              dbo.SOP30200 ON dbo.SOP30300.SOPNUMBE = dbo.SOP30200.SOPNUMBE INNER JOIN
                                              dbo.RM00101 ON dbo.SOP30200.CUSTNMBR = dbo.RM00101.CUSTNMBR INNER JOIN
                                              dbo.IV00101 ON dbo.SOP30300.ITEMNMBR = dbo.IV00101.ITEMNMBR INNER JOIN
                                              dbo.IV40600 ON dbo.IV00101.USCATVLS_1 = dbo.IV40600.USCATVAL
                       WHERE (MONTH(dbo.SOP30200.DOCDATE) = MONTH(GETDATE())) AND (dbo.SOP30300.SOPTYPE IN (3, 4))
                                              AND (dbo.RM00101.CUSTNMBR NOT IN (''AR0075'', ''AR0210''))
                       GROUP BY dbo.RM00101.SALSTERR As XYZ

消息156，级别15，状态1，过程标题_性能，第17行
关键字"As"附近的语法不正确.
我该如何解决这个问题

在此先感谢

Msg 156, Level 15, State 1, Procedure Title_Performance, Line 17
Incorrect syntax near the keyword ''As''.
How can i solve this problem

Thanks in advance

推荐答案

我不认为您应该在Group By旁边添加一个AS.尝试删除该AS并运行您的视图.

I dont think you should be having an AS next to the Group By. Try by removing that AS and running your view.

这篇关于视图无法运行在GroupBy中出现一些问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！