Pak amir, Menurut saya sih tabel itu udah cukup, kolom tanggal lah yg merepresentasikan stock awal/ akhir per kapan Sent from my BlackBerry® powered by Sinyal Kuat INDOSAT
-----Original Message----- From: Amir Yahoo <[email protected]> Sender: [email protected] Date: Sun, 1 Aug 2010 21:09:35 To: indo oracle<[email protected]> Reply-To: [email protected] Subject: [indo-oracle] urgent: Cari stok awal dan akhir dari SQL Server 2000 Dear All, Mohon bantuan dari temen semua ya. Saya sedang membuat program stok. Saat ini sedang kesulitan untuk mencari kolom stok awal dan stok akhir. Dari tabel jurnalgabung yang saya sertakan di attachment, saya sudah buat laporannya seperti ini: jg_tanggal,gud_kode,mat_kode,jg_keterangan,masuk,keluar ------------------------------------------------------------------------------------------- 2010-07-01 00:00:00.000 GD0002 E470900389 MASUK 5000 0 2010-07-01 00:00:00.000 GD0002 M515900005 MASUK 5000 0 2010-07-01 00:00:00.000 GD0005 E470900389 MASUK 5000 0 2010-07-01 00:00:00.000 GD0005 M515900005 MASUK 5000 0 2010-07-01 00:00:00.000 GD0008 E470900389 MASUK 5000 0 2010-07-01 00:00:00.000 GD0008 M515900005 MASUK 5000 0 2010-08-01 00:00:00.000 GD0002 E470900389 MASUK 500 0 2010-08-02 00:00:00.000 GD0002 M515900005 MASUK 600 0 2010-08-03 00:00:00.000 GD0005 E470900389 MASUK 400 0 2010-08-03 00:00:00.000 GD0005 M515900005 MASUK 700 0 2010-08-20 00:00:00.000 GD0002 E470900389 KELUAR 0 500 2010-08-21 00:00:00.000 GD0005 E470900389 KELUAR 0 400 2010-08-22 00:00:00.000 GD0002 M515900005 KELUAR 0 600 2010-08-23 00:00:00.000 GD0005 M515900005 KELUAR 0 1000 Nah maunya sih kita mau buat satu kolom lagi yaitu stokawal (sebelum kolom masuk) dan stokakhir (setelah kolom keluar). Sehingga kurang lebih reportnya seperti ini: jg_tanggal,gud_kode,mat_kode,jg_keterangan,stokawal,masuk,keluar,stokakhir Terimaksih atas bantuan dan pencerahannya.Amir [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------------------ -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [email protected] Website: http://indooracle.wordpress.com http://www.facebook.com/group.php?gid=51973053515 ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.comYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
