|
Dear Lusi, Kalau ada logic sabtu minggu gak dihitung,
maka gak bisa lgs ambil function yg ud available di sql svr, harus bikin
strored proc yg kurang lebih seperti ini. declare @datestart
as datetime declare @dateend
as datetime declare @datepos
as datetime declare @daycount
as int set @datestart =
'11/nov/2005' set @dateend =
'15/nov/2005' set @daycount = 0 set @datepos =
@datestart while @datepos
< @dateend begin
set @datepos = @datepos + 1
if DATENAME(dw, @datepos) not in( 'Saturday', 'Sunday')
begin
set @daycount = @daycount + 1
end
end print @daycount Kalo mau dijadikan dynamic start date dan
end date maka tinggal dijadikan aja sebagai parameter. Semoga membantu Thanks and
Regards, LR. Tonny Soeroso PT. JATIS Solutions Menara Jamsostek Tower A,
16th & 19thFloor Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] YAHOO! GROUPS LINKS
|
