declare upcur cursor for
select (datediff(day,@st_date,@ed_date)+1)-2*datediff(ww,@st_date,@ed_date) --每月要输的天数,没考虑节假日
open upcur --打开
fetch next from upcur into @work_days
select @work_days
fetch next from upcur into @work_days
close upcur --关
deallocate upcur
select (datediff(day,@st_date,@ed_date)+1)-2*datediff(ww,@st_date,@ed_date) --每月要输的天数,没考虑节假日
open upcur --打开
fetch next from upcur into @work_days
select @work_days
fetch next from upcur into @work_days
close upcur --关
deallocate upcur