hehehehe.. iya tuh.. jangan2 kita dari marga yang sama juga neh.. makasih yah buat ide nya, ntar aku coba mas...
salam. Yohanes Iwan Sugiarto wrote: >Hi p. Iwan... nama kita sama ya > kalau menggunakan stored procedure & sub-query gmn? > coba dengan sintaks sql di bawah (saya ngga bisa test bener atau ngga, >mungkin ada sintaks yg perlu disesuaikan dengan Transact-SQL , jarang pakai >soalnya) >jadi coba logika nya saja... kalau berhasil atau ternyata lebih cepat >kabarin kita ya... pengen tahu juga : ) > semoga sih saya ngga salah tangkep maksud p. Iwan & ngga salah2 nulis sql >nya >====================================================== >@kd_organisasi -> input parameter, bisa disesuaikan kalau ingin hanya >mencocokkan bbrp huruf awal saja > >select >tb_mst_organisasi.nm_organisasi , >if t_sd.n_sd is null then 0 else t_sd.n_sd AS sd , >if t_smp.n_smp is null then 0 else t_smp.n_smp AS smp , >if t_sma.n_sma is null then 0 else t_sma.n_sma AS sma , >dst .......... >from >tb_mst_organisasi , >(select count(*) as n_sd from tb_pegawai , tb_tkerja , tb_pdakhir >where tb_pegawai.nik = tb_tkerja.nik and >tb_pegawai.nik = tb_pdakhir.nik and >tb_tkerja.kd_organisasi = @kd_organisasi and tb_tpdakhir.pdakhir = '10') >t_sd , >(select count(*) as n_smp from tb_pegawai , tb_tkerja , tb_pdakhir >where tb_pegawai.nik = tb_tkerja.nik and >tb_pegawai.nik = tb_pdakhir.nik and >tb_tkerja.kd_organisasi = @kd_organisasi and tb_tpdakhir.pdakhir = '21') >t_smp , >(select count(*) as n_sma from tb_pegawai , tb_tkerja , tb_pdakhir >where tb_pegawai.nik = tb_tkerja.nik and >tb_pegawai.nik = tb_pdakhir.nik and >tb_tkerja.kd_organisasi = @kd_organisasi and tb_tpdakhir.pdakhir = 'kode >pdakhir untuk SMA'') t_sma , >dst .......... >================================================= > > ><CUT> > -- >/ i w a n > > >[Non-text portions of this message have been removed] > > > >----------------------------------------------- > INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT >----------------------------------------------- >IndoPB - Indonesia PB User Group >To Post a message, send it to: [EMAIL PROTECTED] >To Unsubscribe,send a blank message to: [EMAIL PROTECTED] >Yahoo! Groups Links > > > > > > > > > > > -- Iwan Setiawan STAF IT PT LGPhilips Displays Kawasan MM2100 Blok G Cikarang Bara - Bekasi 17520 Jawa barat - Indonesia Telp : +21 898 9510/511 HP : 0815 - 911 44 73 Web : http://embun.net ----------------------------------------------- INDOPB TURUT BERDUKA CITA UNTUK ACEH & SUMUT ----------------------------------------------- IndoPB - Indonesia PB User Group To Post a message, send it to: [EMAIL PROTECTED] To Unsubscribe,send a blank message to: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indopb/ <*> 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/
