Welcome to Sign in | Help

Re: Ajutor pt o interogare....

  •  10-23-2007, 12:09 AM

    Re: Ajutor pt o interogare....

    Incearca: 

    WHERE    (SELECT SUM(PRET_UNITAR) FROM dbo.DETAIL_FACTURI WHERE (ID_FACTURA = dbo.ANTET_FACTURI.ID))

    -


    COALESCE((SELECT SUM(PRET_UNITAR) FROM dbo.DETAIL_FACTURI WHERE (ID_FACTURA = dbo.ANTET_FACTURI.ID)) -
        (SELECT SUM(VALOARE) FROM dbo.CHITANTECL WHERE (ID_ANTET_FACTURA = dbo.ANTET_FACTURI.ID)),
        (SELECT SUM(PRET_UNITAR) FROM dbo.DETAIL_FACTURI WHERE (ID_FACTURA = dbo.ANTET_FACTURI.ID)))  > 0

     

    Sau 

    CREATE VIEW Fact

    AS

    SELECT dbo.PARTENERI.NUME,
        dbo.ANTET_FACTURI.ID AS aidi,
        dbo.ANTET_FACTURI.NUMECLIENT,
        dbo.ANTET_FACTURI.NRDOC,
        dbo.ANTET_FACTURI.DATA,
        dbo.ANTET_FACTURI.MONEDA,
        dbo.ANTET_FACTURI.SERIECARD,

        (SELECT SUM(PRET_UNITAR) FROM dbo.DETAIL_FACTURI WHERE (ID_FACTURA = dbo.ANTET_FACTURI.ID)) AS SUMA,

        COALESCE((SELECT SUM(PRET_UNITAR) FROM dbo.DETAIL_FACTURI WHERE (ID_FACTURA = dbo.ANTET_FACTURI.ID)) -
        (SELECT SUM(VALOARE) FROM dbo.CHITANTECL WHERE (ID_ANTET_FACTURA = dbo.ANTET_FACTURI.ID)),
        (SELECT SUM(PRET_UNITAR) FROM dbo.DETAIL_FACTURI WHERE (ID_FACTURA = dbo.ANTET_FACTURI.ID))) AS REST

    FROM dbo.ANTET_FACTURI
        INNER JOIN dbo.PARTENERI ON dbo.ANTET_FACTURI.ID_PARTENER = dbo.PARTENERI.ID

    si

    SELECT *

    FROM Fact

    WHERE Suma - Rest > 0

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems