Link to home
Start Free TrialLog in
Avatar of veshan
veshan

asked on

Server: Msg 170, Level 15, State 1, Procedure UB_GAT, Line 68

Can somebody help me correct script. I get this error

Server: Msg 170, Level 15, State 1, Procedure UB_GAT, Line 68
Line 68: Incorrect syntax near ','.
The line indicates at               PRODUKT_PARTNER), ..in group_ by
.................................................................

create view USH as
select MONAT,
           BLZ,
           ZWEIGSTELLE,
           PRODUKT_PARTNER,
           left(USERID,8) MITARB_USERID_ID,
           MONAT + BLZ + ZWEIGSTELLE + PRODUKT_PARTNER + left(USERID,8) + '                   ' UB_STAT_ID,
           MONAT + 'G' + left(USERID,8) UB_FILTER_U,
           BRUTTO,
           BRUTTO_YTM,
           NETTO,
           NETTO_YTM,
           RUECKFLUSS,
           RUECKFLUSS_YTM,
           BESTAND ,
           ANZ_DEP_NEU,
           ANZ_DEP_NEU_YTM,
           ANZ_DEP
from
(select MONAT,
           BLZ,
           ZWEIGSTELLE,
           PRODUKT_PARTNER,
           sum(BRUTTO) BRUTTO,
           sum(BRUTTO_YTM) BRUTTO_YTM,
           sum(NETTO) NETTO,
           sum(NETTO_YTM) NETTO_YTM,
           sum(RUECKFLUSS) RUECKFLUSS,
           sum(RUECKFLUSS_YTM) RUECKFLUSS_YTM,
           sum(BESTAND) BESTAND ,
           sum(ANZ_DEP_NEU) ANZ_DEP_NEU,
           sum(ANZ_DEP_NEU_YTM) ANZ_DEP_NEU_YTM,
           sum(ANZ_DEP) ANZ_DEP
from UB_stat
where partner = 'BH'
group by MONAT,
             BLZ,
                 ZWEIGSTELLE,
             PRODUKT_PARTNER),
userlogin



ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
By the way, you posted an incomplete query , right?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial