[belajar-access] Simpan 1set query untuk dipakai di query berikutnya

 

Dear Pakar, Mau tanya Misalkan kita ada data sbb : Date COA Debit Credit 01-Jan 11101 100 - 01-Jan 11101 200 - 01-Jan 11101 150 - 01-Jan 11101 - 50 02-Jan 11101 - 50 02-Jan 11101 200 02-Jan 11101 100 - 02-Jan 11101 200 - 02-Jan 11101 150 - 02-Jan 11101 - 50 03-Jan 11101 - 50 03-Jan 11101 200 03-Jan 11101 100 - 03-Jan 11101 200 - 03-Jan 11101 150 - 03-Jan 11101 - 50 Saya ingin pecah data tersebut menjadi Opening Balance, Transaction dan Ending Balance Opening Balance : Select COA, sum(Debit) As OBDebit, Sum(Credit) As OBCredit From dbo.tableName Where Doc_date '2014-02-01') Transaction : Select COA, sum(Debit) As TransDebit, Sum(Credit) As TransCredit From dbo.tableName Where Doc_date Between '2014-02-01' and '2014-03-01' Ending Balance : EBDebit = OBDebit + TransDebit - TransCredit EBCredit = OBCredit - TransDebit + TransCredit Apakah bisa dibuat dalam 1 query / sp di sql server? selama ini saya buat dulu 2 view baru di joint di sp, apakah bisa langsung dibuat dalam setu sp saja? terima kasih Sent from Yahoo Mail on Android

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

SPAM IS PROHIBITED

Visit Your Group

• New Members 5

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___