 Select IMP_LINKID,trim(substring(imp_link.IMP_EXTID from 6 for 12)) EXTGROUP,2 DOOSFDELETE, 'Delete' SDESCRIPTION from imp_link where WGroupid not in(select a.WGroupid from groups a where a.WGroupid = imp_link.WGroupid)
 and imp_sourceid = <@SOURCEID@> and wgroupid is not null and imp_extid like 'OPCR:%'