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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
By the way, you posted an incomplete query , right?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.