Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @Data_do DATE = ':2',
- @Serial_deklaracji INT = :1
- SELECT REPLACE(COALESCE (podatnik.NIP, k.NIP), '-', '') AS NIP
- , COALESCE (podatnik.Kontrahent, k.Kontrahent) AS Dostawca
- , COALESCE (podatnik.Nazwa, k.Nazwa) AS DostawcaNazwa
- FROM Deklaracja_VAT_7_nag AS n
- INNER JOIN
- Dekl_VAT_7_poz_zakup AS vz ON n.Serial = vz.Serial_dokumentu
- AND vz.Kwota_VAT_odlicz <> 0 AND
- n.serial= @Serial_deklaracji
- INNER JOIN
- Dok_zakupu_nag AS z ON z.Serial = vz.Serial_dok_zakupu
- INNER JOIN Kontrahenci_u k ON k.Kontrahent=z.Kontrahent AND
- @Data_do
- BETWEEN k.Wazne_Od AND k.Wazne_Do
- LEFT OUTER JOIN
- Kontrahenci_u AS podatnik ON podatnik.Kontrahent = k.Podatnik AND k.Podatnik <> ''
- AND @Data_do
- BETWEEN podatnik.Wazne_Od AND podatnik.Wazne_Do
- WHERE
- rtrim(REPLACE(COALESCE (podatnik.NIP, k.NIP), '-', ''))+'_'+CONVERT(CHAR(10),@Data_do,121)
- NOT IN (SELECT
- rtrim(bl.NIP)+'_'+CONVERT(CHAR(10),bl.Stan_na_dzien,121)
- FROM BialaLista_wyniki_wyszukiwania bl WHERE bl.StatusVAT='Czynny'
- )
- GROUP BY
- COALESCE (podatnik.Kontrahent, k.Kontrahent)
- , COALESCE (podatnik.Nazwa, k.Nazwa)
- , REPLACE(COALESCE (podatnik.NIP, k.NIP), '-', '')
- ORDER BY Dostawca
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement