Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
create or replace view all_acc_bal as with p as ( select 2013 yr , 12 mn from dual ) select code_trans, -op_deb op_deb, -tr_deb tr_deb, -t_deb t_deb, -op_cr op_cr, -tr_cr tr_cr, -t_cr t_cr, -Bal bal, 'Alpha' Syst FROM h2002_acc_bal t join p on t.year = p.yr and t.period_no= p.mn union all select acc_no, op_deb, tr_deb , op_deb+ tr_deb t_deb , op_cr , tr_cr , op_cr+ tr_cr t_cr, (op_deb+tr_deb)-(op_cr+tr_cr) Bal , 'Intacc' FROM acc_bal f join p on f.year = p.yr and f.period_no= p.mn;
select code_trans , acct_type(code_trans), get_acc_name(code_trans) Acc_Name,sum(bal) Diff from all_acc_bal group by code_trans having sum(bal) > = 1 or sum(bal) < = -1 and code_trans not in('15000','15120','15550','20000','50000','11000') order by sum(bal) desc;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.