hallo zusammen,
wie laeuft das eigentlich muss ich bei ms sql anstatt bei einer ilf-abfrage case angeben? wie schaut das im sql-string aus?
case when blablabla then
blablablo
else blablablu?
end case
gruss manuel!
genauer - darum gehts -
SELECT Count(F_AUFTRAG.KUNDE_ID) AS BIETER, ERF_DATUM,
CASE (WHEN [EMAIL] Is Not Null THEN 1 ELSE 0 END CASE) AS ANZAHL_MAILADRESSEN,
FROM F_AUFTRAG
GROUP BY F_AUFTRAG.ERF_DATUM
Sum(CASE([EMAIL] Is Not Null,1,0)) AS ANZAHL_MAILADRESSEN,
Sum(CASE ([TELEFONMOBIL] Is Not Null,1,0)) AS ANZAHL_MOBILNUMMERN,
Sum(CASE([Anrede] Like ’F%’,1,0)) AS FRAUEN,
Sum(CASE([Anrede] Like ’F%’,1,0))/Count([KUNDENID]) AS FRAUENANTEIL,
Sum(CASE([Anrede] Like ’H%’,1,0)) AS MÄNNER,
Sum(CASE([Anrede] Like ’H%’,1,0))/Count([KUNDENID]) AS MÄNNERANTEIL,
Avg(KUNDEN.ALTER) AS ALTER,
Avg(CASE([ANREDE] Like ’F%’,[Alter])) AS ALTER_FRAUEN,
Avg(CASE([ANREDE] Like ’H%’,[Alter])) AS ALTER_MÄNNER,
Sum(CASE([PLZRECHNUNG] Like ’0%’,1,0)) AS PLZ0,
Sum(CASE([PLZRECHNUNG] Like ’1%’,1,0)) AS PLZ1,
Sum(CASE([PLZRECHNUNG] Like ’2%’,1,0)) AS PLZ2,
Sum(CASE([PLZRECHNUNG] Like ’3%’,1,0)) AS PLZ3,
Sum(CASE([PLZRECHNUNG] Like ’4%’,1,0)) AS PLZ4,
Sum(CASE([PLZRECHNUNG] Like ‘5%’,1,0)) AS PLZ5,
Sum(CASE([PLZRECHNUNG] Like ‘6%’,1,0)) AS PLZ6,
Sum(CASE([PLZRECHNUNG] Like ‘7%’,1,0)) AS PLZ7,
Sum(CASE([PLZRECHNUNG] Like ‘8%’,1,0)) AS PLZ8,
Sum(CASE([PLZRECHNUNG] Like ‘9%’,1,0)) AS PLZ9,
Sum(CASE([PLZRECHNUNG] Like ‘0%’,1,0))/Count([Kundenid]) AS [PLZ0%],
Sum(CASE([PLZRECHNUNG] Like ‘1%’,1,0))/Count([Kundenid]) AS [PLZ1%],
Sum(CASE([PLZRECHNUNG] Like ‘2%’,1,0))/Count([Kundenid]) AS [PLZ2%],
Sum(CASE([PLZRECHNUNG] Like ‘3%’,1,0))/Count([Kundenid]) AS [PLZ3%],
Sum(CASE([PLZRECHNUNG] Like ‘4%’,1,0))/Count([Kundenid]) AS [PLZ4%],
Sum(CASE([PLZRECHNUNG] Like ‘5%’,1,0))/Count([Kundenid]) AS [PLZ5%],
Sum(CASE([PLZRECHNUNG] Like ‘6%’,1,0))/Count([Kundenid]) AS [PLZ6%],
Sum(CASE([PLZRECHNUNG] Like ‘7%’,1,0))/Count([Kundenid]) AS [PLZ7%],
Sum(CASE([PLZRECHNUNG] Like ‘8%’,1,0))/Count([Kundenid]) AS [PLZ8%],
Sum(CASE([PLZRECHNUNG] Like ‘9%’,1,0))/Count([Kundenid]) AS [PLZ9%]
danke
gruss manuel