Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * into #temp_trans_13 from (
- select
- periode,
- konto_nr as ktonr,
- konto_kurztext as ktobez,
- soll_periode - haben_periode as SaldoMonat,
- soll_saldo - haben_saldo as SaldoJahr
- from
- sap_SuSa_liste
- where
- Jahr = :jahr
- and periode = 12
- and buchungskreis = :bkr
- and konto_nr between '200000' and '999999'
- union
- select
- periode,
- konto_nr as ktonr,
- konto_kurztext as ktobez,
- soll_periode - haben_periode as SaldoMonat,
- soll_saldo - haben_saldo as SaldoJahr
- from
- sap_SuSa_liste
- where
- Jahr = :jahr
- and periode = 13
- and buchungskreis = :bkr
- and konto_nr between '200000' and '999999'
- union
- select
- periode,
- konto_nr as ktonr,
- konto_kurztext as ktobez,
- soll_periode - haben_periode as SaldoMonat,
- soll_saldo - haben_saldo as SaldoJahr
- from
- sap_SuSa_liste
- where
- Jahr = :jahr
- and periode = 14
- and buchungskreis = :bkr
- and konto_nr between '200000' and '999999')t
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement