SQLPCM

select ROW_NUMBER()
over
(PARTITION BY Dok.DokId order by Dok.DokId) as 'Numer_pozycji',
Case Dok.TypDok  When 34 Then 'FSK' End As 'Typ_Dokumentu',
Dok.NrDok As 'Numer_Dokumentu',

case magid

when 27 then (case dok.typdok  when 34 then 'k00'end)

when 103 then (case dok.typdok  when 34 then 'k00'end)
end  as 'seria',

CASE
Dok.magid

when 27 then '00'
when 103 then '00'

end as 'Rejestr',

Dok.NrDok as 'Opis',

convert(char(10),Dok.DataDod,120) as 'Data_Dokumentu',
convert(char(10),Dok.Data,120) as 'DataSpr',
('HU' + CAST(Dok.Dokid as varchar)) as 'ID_Pcm' ,
REPLACE(replace(Kontra.Nip,'-',''),' ','') as 'Akronim',


 case
 Dok.FormaPlat
 when 0 then 'Gotówka'
 when 1 then 'Przelew'
 end as 'Forma_płatności',
 convert(char(10),Dok.datadod+Dok.TerminPlat,120) as 'Termin_płatności',

 roz.Netto as 'Wartosc',
 roz.Podatek as 'VAT kwota',


 Case
roz.Stawka
when -1 then 'ZW'
when 0 then '0%'
when 500 then '5%'
when 800 then '8%'
when 2300 then '23%'
end as 'Stawka_VAT',
1 as 'Status_VAT',





roz.NettoDet as 'NettoDet',
roz.PodatekDet as 'PodatekDet'

from hurt201278.dbo.Dok Dok
left join hurt201278.dbo.RozbicieDok roz on Dok.Dokid = roz.Dokid
left join hurt201278.dbo.DokKontr DokKontr on DokKontr.DokId = Dok.DokId
left join hurt201278.dbo.Kontrahent Kontra on Kontra.KontrId = DokKontr.KontrId
left join hurt201278.dbo.rozlicza rozl on dok.dokid = rozl.rozliczanydokid
where
(Dok.TypDok=34) and
roz.netto <> 0 and
 Dok.Data between  getdate()-70 and getdate()-3
and dok.aktywny = 1
order by Dok.Dokid, data