If someone has written some reports that runs only once throughout the semester in infomaker, I am thinking about creating a nsc report which has graduates,graduates needs to be cleanup every beginning of the semester. I just want to run once. Can this be accomplished? If so, how?
Do you know other choices?
I am also sharing my update script:
update NSLC_STUDENT_MAST
set NSL_SPECL_STS_DTE=NULL
from student_crs_hist sch join NSLC_STUDENT_MAST nsc
on sch.ID_NUM=nsc.NSL_ID_NUM
join REG_CONFIG on
sch.YR_CDE=REG_CONFIG.CUR_YR_DFLT
and sch.TRM_CDE=REG_CONFIG.CUR_TRM_DFLT
where sch.yr_cDE=@yr and sch.TRM_CDE=@trm and NSL_SPECL_STS='GR'
Thanks in advance
Do you know other choices?
I am also sharing my update script:
update NSLC_STUDENT_MAST
set NSL_SPECL_STS_DTE=NULL
from student_crs_hist sch join NSLC_STUDENT_MAST nsc
on sch.ID_NUM=nsc.NSL_ID_NUM
join REG_CONFIG on
sch.YR_CDE=REG_CONFIG.CUR_YR_DFLT
and sch.TRM_CDE=REG_CONFIG.CUR_TRM_DFLT
where sch.yr_cDE=@yr and sch.TRM_CDE=@trm and NSL_SPECL_STS='GR'
Thanks in advance