coba bikin view
create view v1 (tanggal, perk, debet, kredit,ket, debet-kredit) as tanggal, perk, debet, kredit, ket, saldo from tabel

mudah2an bisa membantu

Ronald Irawan <[EMAIL PROTECTED]> wrote:

Kalau seperti itu seperti nya lebih baik buat store procedure aja.....

CMIIW
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta



run man <[EMAIL PROTECTED]>
Sent by: [email protected]
07/12/2005 12:17 PM
Please respond to
[email protected]

To
programmer vb <[email protected]>
cc

Subject
[Programmer-VB] Tanya : OOT View SQL Server







rekan2 programmer,
saya punya tabel berisi field
tanggal,perk,debet,kredit,ket.
saya ingin membuat view seperti contoh dibawah ini.
tanggal   perk    debet   kredit  ket    saldo
02/06/05  100101  0       60000   kas    -60000
02/06/05  100101  0       170000  kas    -230000
02/06/05  100101  2200000 0       kas    1970000

mohon petunjuk dari rekan2 apa yang harus saya lakukan
atau mungkin rekan2 punya contoh sebagai bahan rujukan
saya.

Terima kasih


                                 
__________________________________________
Yahoo! DSL – Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com



------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/k7folB/TM
--------------------------------------------------------------------~->

Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]


Yahoo! Groups Links

<*> To visit your group on the web, go to:
   http://groups.yahoo.com/group/Programmer-VB/

<*> 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/






Yahoo! Personals
Let fate take it's course directly to your email.
See who's waiting for you Yahoo! Personals

Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]





SPONSORED LINKS
Programmer Indonesia Basic programming language
Computer programming languages Programming languages Java programming language


YAHOO! GROUPS LINKS




Kirim email ke