select distinct t.primaryManager from tbl_TER_Territories t inner join tbl_TER_TerritoryLevels l on l.levelId = t.levelId inner join tbl_FSpro_members m on m.fspro_userid = t.primaryManager and m.staffMember = 1 where t.ownerId = 1382 and m.fspro_userid <> 1586886 select distinct t.primaryManager from tbl_TER_Territories t inner join tbl_TER_TerritoryLevels l on l.levelId = t.levelId inner join tbl_FSpro_members m on m.fspro_userid = t.primaryManager and m.staffMember = 1 where t.ownerId = 1382 and m.fspro_userid <> 1586886 and t.name like 'REGION%' insert into tbl_SYS_savedreports ( ownerId, ownerType, reportCode, userreportName, userid, reportCenterOptions, parameterString, scheduledDeliveryEmail, scheduledDeliverySubject, scheduledDelivery, scheduledDeliveryStart, txtFormatColumnList, txtFormatColumnLabels ) select ownerId, ownerType, reportCode, userreportName, #primaryManager# userid, reportCenterOptions, parameterString, scheduledDeliveryEmail, scheduledDeliverySubject, scheduledDelivery, scheduledDeliveryStart, txtFormatColumnList, txtFormatColumnLabels from tbl_SYS_savedreports where savedReportId = 4190 insert into tbl_SYS_savedreports ( ownerId, ownerType, reportCode, userreportName, userid, reportCenterOptions, parameterString, scheduledDeliveryEmail, scheduledDeliverySubject, scheduledDelivery, scheduledDeliveryStart, txtFormatColumnList, txtFormatColumnLabels ) select ownerId, ownerType, reportCode, userreportName, #primaryManager# userid, reportCenterOptions, parameterString, scheduledDeliveryEmail, scheduledDeliverySubject, scheduledDelivery, scheduledDeliveryStart, txtFormatColumnList, txtFormatColumnLabels from tbl_SYS_savedreports where savedReportId = 4189