Abfrage nach Monaten

A

Alex02

Mitglied
Hallo,

ich hab da ein kleines Problem:

Ich soll eine Abfrage machen, die als Ergebnis folgendes liefert:
Code: 
Zuordnung     Kst    Jan     Febr    …
------------  -----  ------  ------
Fachwissen    100    Wert    Wert
Sprachen      100    Wert    Wert
…
Fachwis.      110    Wert    Wert
Sprachen      100    Wert    Wert
…

Die Werte sollen kumulieren pro Monat (sind in der Datenbank für die einzelnen Zuordnungen vohanden) werden.

Ich hab jetzt folgende Abfrage:
Code: 
SELECT     L_KSTUSERINTEGER_9514C783 AS Kst, STR_ZUORDNUNGSHORTTEX_B477DB7F AS Zuordnung,
                          (SELECT     SUM(FLT_SEMINARKOSTENFLOA_5B353FBD)
                              FROM         XDATAGROUPE9E24520
                              WHERE     (YEAR(DT_ENDEDATETIME_8A2AA411) = YEAR({ fn NOW() })) AND (FLT_SEMINARKOSTENFLOA_5B353FBD IS NOT NULL) AND 
                                                    MONTH(DT_ENDEDATETIME_8A2AA411) = '1') AS Seminarkosten
FROM         XDATAGROUPE9E24520
WHERE     (YEAR(DT_ENDEDATETIME_8A2AA411) = YEAR({ fn NOW() })) AND (FLT_SEMINARKOSTENFLOA_5B353FBD IS NOT NULL)
GROUP BY L_KSTUSERINTEGER_9514C783, STR_ZUORDNUNGSHORTTEX_B477DB7F
ORDER BY L_KSTUSERINTEGER_9514C783

Diese Unterabfrage liefert mir jedoch nur einen einzigen Wert. Dieser wir überall eingesetzt.

Kann ich die Abfrage irgendwie so machen, dass der Wert pro Kostenstelle und Zuordnung im jeweiligen Monat angezeigt wird

(Ich hoff das, dass was ich oben fabriziert hab, verständlich ist)

Wäre für jeden Tipp sehr dankbar.

Gruß

Alex
 
Zuletzt bearbeitet:
Hi, ich poste mal die komplette Query:
Code: 
SELECT     XDATAGROUPE9E24520.L_KSTUSERINTEGER_9514C783 AS Kst, XDATAGROUPE9E24520.STR_ZUORDNUNGSHORTTEX_B477DB7F AS Zuordnung, 
                      COUNT(AbfrJan.BdgJan) AS Januar, COUNT(AbfrFeb.BdgFeb) AS Februar, COUNT(AbfrMar.BdgMar) AS März, COUNT(AbfrApr.BdgApr) AS April, 
                      COUNT(AbfrMai.BdgMai) AS Mail, COUNT(AbfrJun.BdgJun) AS Juni, COUNT(AbfrJul.BdgJul) AS Juli, COUNT(AbfrAug.BdgAug) AS August, 
                      COUNT(AbfrSep.BdgSep) AS September, COUNT(AbfrOkt.BdgOkt) AS Oktober, COUNT(AbfrNov.BdgNov) AS November, COUNT(AbfrDez.BdgDez) 
                      AS Dezember, COUNT(AbfrGes.BdgGes) AS ZuordnJeKstJeZuordn
FROM         XDATAGROUPE9E24520 LEFT OUTER JOIN
                          (SELECT     L_KSTUSERINTEGER_9514C783 AS JanKst, STR_ZUORDNUNGSHORTTEX_B477DB7F AS zuord, 
                                                   SUM(FLT_SEMINARKOSTENFLOA_5B353FBD) AS BdgJan, SUM(MONTH(DT_ENDEDATETIME_8A2AA411)) 
                                                   / COUNT(MONTH(DT_ENDEDATETIME_8A2AA411)) AS Mon
                            FROM          XDATAGROUPE9E24520
                            WHERE      (FLT_SEMINARKOSTENFLOA_5B353FBD IS NOT NULL) AND (MONTH(DT_ENDEDATETIME_8A2AA411) = '1') AND 
                                                   (YEAR(DT_ENDEDATETIME_8A2AA411) = YEAR({ fn NOW() }) AND (B_STORNIERUNGBOOLEAN_BAB3A8CF = '0' OR
                                                   B_STORNIERUNGBOOLEAN_BAB3A8CF IS NULL) AND (B_BESCHAFFUNGSANTRAGB_4D97F777 = '0' OR
                                                   B_BESCHAFFUNGSANTRAGB_4D97F777 IS NULL) AND STR_PRIORITTSHORTTEXT_FA3702B6 <> '3')
                            GROUP BY L_KSTUSERINTEGER_9514C783, STR_ZUORDNUNGSHORTTEX_B477DB7F) AbfrJan ON 
                      XDATAGROUPE9E24520.L_KSTUSERINTEGER_9514C783 = AbfrJan.JanKst AND 
                      XDATAGROUPE9E24520.STR_ZUORDNUNGSHORTTEX_B477DB7F = AbfrJan.zuord AND 
                      MONTH(XDATAGROUPE9E24520.DT_ENDEDATETIME_8A2AA411) = AbfrJan.Mon LEFT OUTER JOIN
                          (SELECT     L_KSTUSERINTEGER_9514C783 AS FebKst, STR_ZUORDNUNGSHORTTEX_B477DB7F AS zuord, 
                                                   SUM(FLT_SEMINARKOSTENFLOA_5B353FBD) AS BdgFeb, SUM(MONTH(DT_ENDEDATETIME_8A2AA411)) 
                                                   / COUNT(MONTH(DT_ENDEDATETIME_8A2AA411)) AS Mon
                            FROM          XDATAGROUPE9E24520
                            WHERE      (FLT_SEMINARKOSTENFLOA_5B353FBD IS NOT NULL) AND (MONTH(DT_ENDEDATETIME_8A2AA411) = '2') AND 
                                                   (YEAR(DT_ENDEDATETIME_8A2AA411) = YEAR({ fn NOW() }) AND (B_STORNIERUNGBOOLEAN_BAB3A8CF = '0' OR
                                                   B_STORNIERUNGBOOLEAN_BAB3A8CF IS NULL) AND (B_BESCHAFFUNGSANTRAGB_4D97F777 = '0' OR
                                                   B_BESCHAFFUNGSANTRAGB_4D97F777 IS NULL) AND STR_PRIORITTSHORTTEXT_FA3702B6 <> '3')
                            GROUP BY L_KSTUSERINTEGER_9514C783, STR_ZUORDNUNGSHORTTEX_B477DB7F) AbfrFeb ON 
                      XDATAGROUPE9E24520.L_KSTUSERINTEGER_9514C783 = AbfrFeb.FebKst AND 
                      XDATAGROUPE9E24520.STR_ZUORDNUNGSHORTTEX_B477DB7F = AbfrFeb.zuord AND 
                      MONTH(XDATAGROUPE9E24520.DT_ENDEDATETIME_8A2AA411) = AbfrFeb.Mon LEFT OUTER JOIN
                          (SELECT     L_KSTUSERINTEGER_9514C783 AS MarKst, STR_ZUORDNUNGSHORTTEX_B477DB7F AS zuord, 
                                                   SUM(FLT_SEMINARKOSTENFLOA_5B353FBD) AS BdgMar, SUM(MONTH(DT_ENDEDATETIME_8A2AA411)) 
                                                   / COUNT(MONTH(DT_ENDEDATETIME_8A2AA411)) AS Mon
                            FROM          XDATAGROUPE9E24520
                            WHERE      (FLT_SEMINARKOSTENFLOA_5B353FBD IS NOT NULL) AND (MONTH(DT_ENDEDATETIME_8A2AA411) = '3') AND 
                                                   (YEAR(DT_ENDEDATETIME_8A2AA411) = YEAR({ fn NOW() }) AND (B_STORNIERUNGBOOLEAN_BAB3A8CF = '0' OR
                                                   B_STORNIERUNGBOOLEAN_BAB3A8CF IS NULL) AND (B_BESCHAFFUNGSANTRAGB_4D97F777 = '0' OR
                                                   B_BESCHAFFUNGSANTRAGB_4D97F777 IS NULL) AND STR_PRIORITTSHORTTEXT_FA3702B6 <> '3')
                            GROUP BY L_KSTUSERINTEGER_9514C783, STR_ZUORDNUNGSHORTTEX_B477DB7F) AbfrMar ON 
                      XDATAGROUPE9E24520.L_KSTUSERINTEGER_9514C783 = AbfrMar.MarKst AND 
                      XDATAGROUPE9E24520.STR_ZUORDNUNGSHORTTEX_B477DB7F = AbfrMar.zuord AND 
                      MONTH(XDATAGROUPE9E24520.DT_ENDEDATETIME_8A2AA411) = AbfrMar.Mon LEFT OUTER JOIN
                          (SELECT     L_KSTUSERINTEGER_9514C783 AS AprKst, STR_ZUORDNUNGSHORTTEX_B477DB7F AS zuord, 
                                                   SUM(FLT_SEMINARKOSTENFLOA_5B353FBD) AS BdgApr, SUM(MONTH(DT_ENDEDATETIME_8A2AA411)) 
                                                   / COUNT(MONTH(DT_ENDEDATETIME_8A2AA411)) AS Mon
                            FROM          XDATAGROUPE9E24520
                            WHERE      (FLT_SEMINARKOSTENFLOA_5B353FBD IS NOT NULL) AND (MONTH(DT_ENDEDATETIME_8A2AA411) = '4') AND 
                                                   (YEAR(DT_ENDEDATETIME_8A2AA411) = YEAR({ fn NOW() }) AND (B_STORNIERUNGBOOLEAN_BAB3A8CF = '0' OR
                                                   B_STORNIERUNGBOOLEAN_BAB3A8CF IS NULL) AND (B_BESCHAFFUNGSANTRAGB_4D97F777 = '0' OR
                                                   B_BESCHAFFUNGSANTRAGB_4D97F777 IS NULL) AND STR_PRIORITTSHORTTEXT_FA3702B6 <> '3')
                            GROUP BY L_KSTUSERINTEGER_9514C783, STR_ZUORDNUNGSHORTTEX_B477DB7F) AbfrApr ON 
                      XDATAGROUPE9E24520.L_KSTUSERINTEGER_9514C783 = AbfrApr.AprKst AND 
                      XDATAGROUPE9E24520.STR_ZUORDNUNGSHORTTEX_B477DB7F = AbfrApr.zuord AND 
                      MONTH(XDATAGROUPE9E24520.DT_ENDEDATETIME_8A2AA411) = AbfrApr.Mon LEFT OUTER JOIN
                          (SELECT     L_KSTUSERINTEGER_9514C783 AS MaiKst, STR_ZUORDNUNGSHORTTEX_B477DB7F AS zuord, 
                                                   SUM(FLT_SEMINARKOSTENFLOA_5B353FBD) AS BdgMai, SUM(MONTH(DT_ENDEDATETIME_8A2AA411)) 
                                                   / COUNT(MONTH(DT_ENDEDATETIME_8A2AA411)) AS Mon
                            FROM          XDATAGROUPE9E24520
                            WHERE      (FLT_SEMINARKOSTENFLOA_5B353FBD IS NOT NULL) AND (MONTH(DT_ENDEDATETIME_8A2AA411) = '5') AND 
                                                   (YEAR(DT_ENDEDATETIME_8A2AA411) = YEAR({ fn NOW() }) AND (B_STORNIERUNGBOOLEAN_BAB3A8CF = '0' OR
                                                   B_STORNIERUNGBOOLEAN_BAB3A8CF IS NULL) AND (B_BESCHAFFUNGSANTRAGB_4D97F777 = '0' OR
                                                   B_BESCHAFFUNGSANTRAGB_4D97F777 IS NULL) AND STR_PRIORITTSHORTTEXT_FA3702B6 <> '3')
                            GROUP BY L_KSTUSERINTEGER_9514C783, STR_ZUORDNUNGSHORTTEX_B477DB7F) AbfrMai ON 
                      XDATAGROUPE9E24520.L_KSTUSERINTEGER_9514C783 = AbfrMai.MaiKst AND 
                      XDATAGROUPE9E24520.STR_ZUORDNUNGSHORTTEX_B477DB7F = AbfrMai.zuord AND 
                      MONTH(XDATAGROUPE9E24520.DT_ENDEDATETIME_8A2AA411) = AbfrMai.Mon LEFT OUTER JOIN
                          (SELECT     L_KSTUSERINTEGER_9514C783 AS JunKst, STR_ZUORDNUNGSHORTTEX_B477DB7F AS zuord, 
                                                   SUM(FLT_SEMINARKOSTENFLOA_5B353FBD) AS BdgJun, SUM(MONTH(DT_ENDEDATETIME_8A2AA411)) 
                                                   / COUNT(MONTH(DT_ENDEDATETIME_8A2AA411)) AS Mon
                            FROM          XDATAGROUPE9E24520
                            WHERE      (FLT_SEMINARKOSTENFLOA_5B353FBD IS NOT NULL) AND (MONTH(DT_ENDEDATETIME_8A2AA411) = '6') AND 
                                                   (YEAR(DT_ENDEDATETIME_8A2AA411) = YEAR({ fn NOW() }) AND (B_STORNIERUNGBOOLEAN_BAB3A8CF = '0' OR
                                                   B_STORNIERUNGBOOLEAN_BAB3A8CF IS NULL) AND (B_BESCHAFFUNGSANTRAGB_4D97F777 = '0' OR
                                                   B_BESCHAFFUNGSANTRAGB_4D97F777 IS NULL) AND STR_PRIORITTSHORTTEXT_FA3702B6 <> '3')
                            GROUP BY L_KSTUSERINTEGER_9514C783, STR_ZUORDNUNGSHORTTEX_B477DB7F) AbfrJun ON 
                      XDATAGROUPE9E24520.L_KSTUSERINTEGER_9514C783 = AbfrJun.JunKst AND 
                      XDATAGROUPE9E24520.STR_ZUORDNUNGSHORTTEX_B477DB7F = AbfrJun.zuord AND 
                      MONTH(XDATAGROUPE9E24520.DT_ENDEDATETIME_8A2AA411) = AbfrJun.Mon LEFT OUTER JOIN
                          (SELECT     L_KSTUSERINTEGER_9514C783 AS JulKst, STR_ZUORDNUNGSHORTTEX_B477DB7F AS zuord, 
                                                   SUM(FLT_SEMINARKOSTENFLOA_5B353FBD) AS BdgJul, SUM(MONTH(DT_ENDEDATETIME_8A2AA411)) 
                                                   / COUNT(MONTH(DT_ENDEDATETIME_8A2AA411)) AS Mon
                            FROM          XDATAGROUPE9E24520
                            WHERE      (FLT_SEMINARKOSTENFLOA_5B353FBD IS NOT NULL) AND (MONTH(DT_ENDEDATETIME_8A2AA411) = '7') AND 
                                                   (YEAR(DT_ENDEDATETIME_8A2AA411) = YEAR({ fn NOW() }) AND (B_STORNIERUNGBOOLEAN_BAB3A8CF = '0' OR
                                                   B_STORNIERUNGBOOLEAN_BAB3A8CF IS NULL) AND (B_BESCHAFFUNGSANTRAGB_4D97F777 = '0' OR
                                                   B_BESCHAFFUNGSANTRAGB_4D97F777 IS NULL) AND STR_PRIORITTSHORTTEXT_FA3702B6 <> '3')
                            GROUP BY L_KSTUSERINTEGER_9514C783, STR_ZUORDNUNGSHORTTEX_B477DB7F) AbfrJul ON 
                      XDATAGROUPE9E24520.L_KSTUSERINTEGER_9514C783 = AbfrJul.JulKst AND 
                      XDATAGROUPE9E24520.STR_ZUORDNUNGSHORTTEX_B477DB7F = AbfrJul.zuord AND 
                      MONTH(XDATAGROUPE9E24520.DT_ENDEDATETIME_8A2AA411) = AbfrJul.Mon LEFT OUTER JOIN
                          (SELECT     L_KSTUSERINTEGER_9514C783 AS AugKst, STR_ZUORDNUNGSHORTTEX_B477DB7F AS zuord, 
                                                   SUM(FLT_SEMINARKOSTENFLOA_5B353FBD) AS BdgAug, SUM(MONTH(DT_ENDEDATETIME_8A2AA411)) 
                                                   / COUNT(MONTH(DT_ENDEDATETIME_8A2AA411)) AS Mon
                            FROM          XDATAGROUPE9E24520
                            WHERE      (FLT_SEMINARKOSTENFLOA_5B353FBD IS NOT NULL) AND (MONTH(DT_ENDEDATETIME_8A2AA411) = '8') AND 
                                                   (YEAR(DT_ENDEDATETIME_8A2AA411) = YEAR({ fn NOW() }) AND (B_STORNIERUNGBOOLEAN_BAB3A8CF = '0' OR
                                                   B_STORNIERUNGBOOLEAN_BAB3A8CF IS NULL) AND (B_BESCHAFFUNGSANTRAGB_4D97F777 = '0' OR
                                                   B_BESCHAFFUNGSANTRAGB_4D97F777 IS NULL) AND STR_PRIORITTSHORTTEXT_FA3702B6 <> '3')
                            GROUP BY L_KSTUSERINTEGER_9514C783, STR_ZUORDNUNGSHORTTEX_B477DB7F) AbfrAug ON 
                      XDATAGROUPE9E24520.L_KSTUSERINTEGER_9514C783 = AbfrAug.AugKst AND 
                      XDATAGROUPE9E24520.STR_ZUORDNUNGSHORTTEX_B477DB7F = AbfrAug.zuord AND 
                      MONTH(XDATAGROUPE9E24520.DT_ENDEDATETIME_8A2AA411) = AbfrAug.Mon LEFT OUTER JOIN
                          (SELECT     L_KSTUSERINTEGER_9514C783 AS SepKst, STR_ZUORDNUNGSHORTTEX_B477DB7F AS zuord, 
                                                   SUM(FLT_SEMINARKOSTENFLOA_5B353FBD) AS BdgSep, SUM(MONTH(DT_ENDEDATETIME_8A2AA411)) 
                                                   / COUNT(MONTH(DT_ENDEDATETIME_8A2AA411)) AS Mon
                            FROM          XDATAGROUPE9E24520
                            WHERE      (FLT_SEMINARKOSTENFLOA_5B353FBD IS NOT NULL) AND (MONTH(DT_ENDEDATETIME_8A2AA411) = '9') AND 
                                                   (YEAR(DT_ENDEDATETIME_8A2AA411) = YEAR({ fn NOW() }) AND (B_STORNIERUNGBOOLEAN_BAB3A8CF = '0' OR
                                                   B_STORNIERUNGBOOLEAN_BAB3A8CF IS NULL) AND (B_BESCHAFFUNGSANTRAGB_4D97F777 = '0' OR
                                                   B_BESCHAFFUNGSANTRAGB_4D97F777 IS NULL) AND STR_PRIORITTSHORTTEXT_FA3702B6 <> '3')
                            GROUP BY L_KSTUSERINTEGER_9514C783, STR_ZUORDNUNGSHORTTEX_B477DB7F) AbfrSep ON 
                      XDATAGROUPE9E24520.L_KSTUSERINTEGER_9514C783 = AbfrSep.SepKst AND 
                      XDATAGROUPE9E24520.STR_ZUORDNUNGSHORTTEX_B477DB7F = AbfrSep.zuord AND 
                      MONTH(XDATAGROUPE9E24520.DT_ENDEDATETIME_8A2AA411) = AbfrSep.Mon LEFT OUTER JOIN
                          (SELECT     L_KSTUSERINTEGER_9514C783 AS OktKst, STR_ZUORDNUNGSHORTTEX_B477DB7F AS zuord, 
                                                   SUM(FLT_SEMINARKOSTENFLOA_5B353FBD) AS BdgOkt, SUM(MONTH(DT_ENDEDATETIME_8A2AA411)) 
                                                   / COUNT(MONTH(DT_ENDEDATETIME_8A2AA411)) AS Mon
                            FROM          XDATAGROUPE9E24520
                            WHERE      (FLT_SEMINARKOSTENFLOA_5B353FBD IS NOT NULL) AND (MONTH(DT_ENDEDATETIME_8A2AA411) = '10') AND 
                                                   (YEAR(DT_ENDEDATETIME_8A2AA411) = YEAR({ fn NOW() }) AND (B_STORNIERUNGBOOLEAN_BAB3A8CF = '0' OR
                                                   B_STORNIERUNGBOOLEAN_BAB3A8CF IS NULL) AND (B_BESCHAFFUNGSANTRAGB_4D97F777 = '0' OR
                                                   B_BESCHAFFUNGSANTRAGB_4D97F777 IS NULL) AND STR_PRIORITTSHORTTEXT_FA3702B6 <> '3')
                            GROUP BY L_KSTUSERINTEGER_9514C783, STR_ZUORDNUNGSHORTTEX_B477DB7F) AbfrOkt ON 
                      XDATAGROUPE9E24520.L_KSTUSERINTEGER_9514C783 = AbfrOkt.OktKst AND 
                      XDATAGROUPE9E24520.STR_ZUORDNUNGSHORTTEX_B477DB7F = AbfrOkt.zuord AND 
                      MONTH(XDATAGROUPE9E24520.DT_ENDEDATETIME_8A2AA411) = AbfrOkt.Mon LEFT OUTER JOIN
                          (SELECT     L_KSTUSERINTEGER_9514C783 AS NovKst, STR_ZUORDNUNGSHORTTEX_B477DB7F AS zuord, 
                                                   SUM(FLT_SEMINARKOSTENFLOA_5B353FBD) AS BdgNov, SUM(MONTH(DT_ENDEDATETIME_8A2AA411)) 
                                                   / COUNT(MONTH(DT_ENDEDATETIME_8A2AA411)) AS Mon
                            FROM          XDATAGROUPE9E24520
                            WHERE      (FLT_SEMINARKOSTENFLOA_5B353FBD IS NOT NULL) AND (MONTH(DT_ENDEDATETIME_8A2AA411) = '11') AND 
                                                   (YEAR(DT_ENDEDATETIME_8A2AA411) = YEAR({ fn NOW() }) AND (B_STORNIERUNGBOOLEAN_BAB3A8CF = '0' OR
                                                   B_STORNIERUNGBOOLEAN_BAB3A8CF IS NULL) AND (B_BESCHAFFUNGSANTRAGB_4D97F777 = '0' OR
                                                   B_BESCHAFFUNGSANTRAGB_4D97F777 IS NULL) AND STR_PRIORITTSHORTTEXT_FA3702B6 <> '3')
                            GROUP BY L_KSTUSERINTEGER_9514C783, STR_ZUORDNUNGSHORTTEX_B477DB7F) AbfrNov ON 
                      XDATAGROUPE9E24520.L_KSTUSERINTEGER_9514C783 = AbfrNov.NovKst AND 
                      XDATAGROUPE9E24520.STR_ZUORDNUNGSHORTTEX_B477DB7F = AbfrNov.zuord AND 
                      MONTH(XDATAGROUPE9E24520.DT_ENDEDATETIME_8A2AA411) = AbfrNov.Mon LEFT OUTER JOIN
                          (SELECT     L_KSTUSERINTEGER_9514C783 AS DezKst, STR_ZUORDNUNGSHORTTEX_B477DB7F AS zuord, 
                                                   SUM(FLT_SEMINARKOSTENFLOA_5B353FBD) AS BdgDez, SUM(MONTH(DT_ENDEDATETIME_8A2AA411)) 
                                                   / COUNT(MONTH(DT_ENDEDATETIME_8A2AA411)) AS Mon
                            FROM          XDATAGROUPE9E24520
                            WHERE      (FLT_SEMINARKOSTENFLOA_5B353FBD IS NOT NULL) AND (MONTH(DT_ENDEDATETIME_8A2AA411) = '12') AND 
                                                   (YEAR(DT_ENDEDATETIME_8A2AA411) = YEAR({ fn NOW() }) AND (B_STORNIERUNGBOOLEAN_BAB3A8CF = '0' OR
                                                   B_STORNIERUNGBOOLEAN_BAB3A8CF IS NULL) AND (B_BESCHAFFUNGSANTRAGB_4D97F777 = '0' OR
                                                   B_BESCHAFFUNGSANTRAGB_4D97F777 IS NULL) AND STR_PRIORITTSHORTTEXT_FA3702B6 <> '3')
                            GROUP BY L_KSTUSERINTEGER_9514C783, STR_ZUORDNUNGSHORTTEX_B477DB7F) AbfrDez ON 
                      XDATAGROUPE9E24520.L_KSTUSERINTEGER_9514C783 = AbfrDez.DezKst AND 
                      XDATAGROUPE9E24520.STR_ZUORDNUNGSHORTTEX_B477DB7F = AbfrDez.zuord AND 
                      MONTH(XDATAGROUPE9E24520.DT_ENDEDATETIME_8A2AA411) = AbfrDez.Mon LEFT OUTER JOIN
                          (SELECT     L_KSTUSERINTEGER_9514C783 AS GesKst, STR_ZUORDNUNGSHORTTEX_B477DB7F AS zuord, 
                                                   SUM(FLT_SEMINARKOSTENFLOA_5B353FBD) AS BdgGes
                            FROM          XDATAGROUPE9E24520
                            WHERE      (FLT_SEMINARKOSTENFLOA_5B353FBD IS NOT NULL) AND (YEAR(DT_ENDEDATETIME_8A2AA411) = YEAR({ fn NOW() }) AND 
                                                   (B_STORNIERUNGBOOLEAN_BAB3A8CF = '0' OR
                                                   B_STORNIERUNGBOOLEAN_BAB3A8CF IS NULL) AND B_BESCHAFFUNGSANTRAGB_4D97F777 = '0' AND 
                                                   STR_PRIORITTSHORTTEXT_FA3702B6 <> '3')
                            GROUP BY L_KSTUSERINTEGER_9514C783, STR_ZUORDNUNGSHORTTEX_B477DB7F) AbfrGes ON 
                      XDATAGROUPE9E24520.L_KSTUSERINTEGER_9514C783 = AbfrGes.GesKst AND 
                      XDATAGROUPE9E24520.STR_ZUORDNUNGSHORTTEX_B477DB7F = AbfrGes.zuord
WHERE     (XDATAGROUPE9E24520.FLT_SEMINARKOSTENFLOA_5B353FBD IS NOT NULL) AND (YEAR(XDATAGROUPE9E24520.DT_ENDEDATETIME_8A2AA411) 
                      = YEAR({ fn NOW() })) AND (XDATAGROUPE9E24520.B_BESCHAFFUNGSANTRAGB_4D97F777 = '0')
GROUP BY XDATAGROUPE9E24520.L_KSTUSERINTEGER_9514C783, XDATAGROUPE9E24520.STR_ZUORDNUNGSHORTTEX_B477DB7F
ORDER BY XDATAGROUPE9E24520.L_KSTUSERINTEGER_9514C783

Gruß

Alex
 
Um antworten zu können musst du eingeloggt sein.

Neue Beiträge

Zurück