select distinct ownerId, fsl_tablecode from tbl_FSPro_members where allowSuperUser = 'Y' and fsl_tablecode in ( 'MFR', 'BRO' ) and loginEnabled = 1 and ownerId > 0 select fspro_userId from tbl_Fspro_members where ownerId = and fsl_tablecode = and email = 'developer@fsenablers.com' insert into tbl_FSPro_members ( ownerId, fsl_tablecode, loginEnabled, fspro_password, email, firstName, lastName, allowSuperUser ) values( , , 1, 'developer', 'developer@fsenablers.com', 'Fred', 'Brooks', 'Y' ) select g.groupId from tbl_SEC_Groups g inner join tbl_SEC_AttrbGrpLink agl on agl.groupId = g.groupId where g.ownerId = and g.fsl_tablecode = and g.groupName like '%FSE%' and agl.attrbId in ( select a.attrbId from tbl_SEC_AttributeTypes at inner join tbl_SEC_Attributes a on a.attrbTypeId= at.attrbTypeId where at.attrbtypeCode = 'STP' and a.ownerId = and a.fsl_tablecode = ) insert into tbl_SEC_MemGrpLink ( fspro_userId, groupId ) values( , )