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