Welcome, guest! Login / Register - Why register?
Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)

Paste

Pasted as SQL by rome ( 11 years ago )
SELECT
    SUM(SUMME.UNBEARBEITET) AS UNBEARBEITET,
    SUM(SUMME.GESAMT) AS GESAMT
FROM (
        SELECT
            COUNT(*) AS UNBEARBEITET,
            0        AS GESAMT
        FROM
            IM_POSTEINGANG P1
        WHERE
            P1.SACHBEARBEITER_PK = 1
        AND P1.PROCESSED_DATE IS NOT NULL
        UNION
        SELECT
            0        AS UNBEARBEITET,
            COUNT(*) AS GESAMT
        FROM
            IM_POSTEINGANG P2
        WHERE
            P2.SACHBEARBEITER_PK = 1
) AS SUMME

 

Revise this Paste

Your Name: Code Language: