insert  MSP_WEB_WORK_APPROVAL(WASSN_ID,WRES_ID,WPRD_START_DATE,WPRD_FINISH_DATE,WRES_ID_APPROVER,WAPPROVAL_STATUS,WAPPROVAL_NOTIFICATION_SENT)SELECT WASSN_ID,WRES_ID,WPRD_START_DATE,WPRD_FINISH_DATE,WRES_ID,1,0FROM MSP_WEB_ASSIGNMENTS MWA, MSP_WEB_TIME_PERIODS mwpWHERE Not Exists (select * from MSP_WEB_WORK_APPROVAL where CONVERT(VARCHAR,