Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- o.ID,
- o.Number AS [Numer dokumentu],
- o.DocumentDate AS [Data],
- CASE WHEN d.FIRMA IS NULL THEN k.NAZWA
- ELSE d.FIRMA END AS [Nazwa],
- CASE WHEN d.FIRMA IS NULL THEN K.ULICA_LOKAL
- ELSE D.ULICA_LOKAL END AS [Ulica],
- CASE WHEN d.FIRMA IS NULL THEN K.MIEJSCOWOSC
- ELSE D.MIEJSCOWOSC END AS [Miasto],
- K.NIP AS [NIP],
- A.NAZWA AS [Nazwa],
- J.NAZWA AS [JM],
- op.BuyPriceNet AS [Cena zakupu],
- op.FixedPrice AS [Stała cena],
- op.Margin AS [Marża],
- CASE WHEN op.FixedPrice = 0 OR op.FixedPrice IS NULL THEN (op.BuyPriceNet*op.Margin)+op.BuyPriceNet
- WHEN op.FixedPrice != 0 THEN op.FixedPrice
- ELSE 0.00 END AS [Cena sprzedaży Netto],
- CASE WHEN op.FixedPrice = 0 OR op.FixedPrice IS NULL THEN ((op.BuyPriceNet*op.Margin)+op.BuyPriceNet)*((100+CAST(a.VAT_SPRZEDAZY AS DEC(10,2)))/100)
- WHEN op.FixedPrice != 0 THEN op.FixedPrice*((100+CAST(a.VAT_SPRZEDAZY AS DEC(10,2)))/100)
- ELSE 0.00 END AS [Cena sprzedaży Brutto],
- (SELECT NAZWA FROM WaProNowa.dbo.KATEGORIA_ARTYKULU_TREE WHERE KOD_TREE = LEFT(KAT.KOD_TREE,3) AND LEN(KOD_TREE)=3) AS L1,
- (SELECT NAZWA FROM WaProNowa.dbo.KATEGORIA_ARTYKULU_TREE WHERE KOD_TREE = LEFT(KAT.KOD_TREE,6) AND LEN(KOD_TREE)=6) AS L2,
- (SELECT NAZWA FROM WaProNowa.dbo.KATEGORIA_ARTYKULU_TREE WHERE KOD_TREE = LEFT(KAT.KOD_TREE,9) AND LEN(KOD_TREE)=9) AS L3,
- (SELECT NAZWA FROM WaProNowa.dbo.KATEGORIA_ARTYKULU_TREE WHERE KOD_TREE = LEFT(KAT.KOD_TREE,12) AND LEN(KOD_TREE)=12) AS L4
- FROM DBO.Offers o
- LEFT JOIN DBO.KONTRAHENT k ON k.ID_KONTRAHENTA = o.CustomerId
- LEFT JOIN DBO.MIEJSCE_DOSTAWY d ON O.CustomerId = D.ID_KONTRAHENTA AND o.CustomerAddressId = d.ID_MIEJSCA_DOSTAWY
- LEFT JOIN DBO.OfferPositions op ON o.ID = OP.OfferId
- LEFT JOIN DBO.ARTYKUL a ON A.ID_ARTYKULU = OP.ArticleId
- LEFT JOIN DBO.KATEGORIA_ARTYKULU_TREE KAT ON A.ID_KATEGORII_TREE = KAT.ID_KATEGORII_TREE
- LEFT JOIN DBO.JEDNOSTKA J ON J.ID_JEDNOSTKI = A.ID_JEDNOSTKI
- WHERE o.ID = @ObjectID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement