SQL 305 PENGUKURAN

305 per kegiatan (prosedur 82,191,192) perbulan.


select expe.expecod,expe.expeyea,
d305.d305seq,d305.d305yea,
tind.tinddes,
exco.excoamo,exco.tpaycod,exco.tpaydes
from d305,tind,exco,expe
where d305.tindcod in ("80","83","11","12","03","84","87","54","55")
and d305.tindcod=tind.tindcod
and d305.expeid=exco.expeid
and expe.expeid=d305.expeid
and month(d305.d305dat)="01" -----> Bulan Januari
{and d305.d305dat="11/01/2005"} --> kalau mau perhari
and year(d305.d305dat)=2005 -----> Tahun 2005
group by 5,3,2,1,4,6,7,8;


Prosedur 82,191,192

Prosedur | Jenis Kegiatan | Deskripsi Kegiatan
Prosedur 82 80 Konversi
83 Pengakuan Hak

Prosedur 820 84 Konversi (SU sudah ada)
87 Pengakuan Hak (SU sudah ada)

Prosedur 823 54 Konversi (SU sudah ada, Belum Pengumuman)
55 Pengakuan Hak (SU sudah ada, Belum Pengumuman)

Prosedur 191 11 Pecah Sempurna
12 Pemisahan (Pecah Sebagian)

Prosedur 192 03 Penggabungan

bpnjember@yahoo.com