select keyWords from tbl_DOC_Documents with (nolock) where ownerId = and fsl_tablecode = and docId = update tbl_DOC_Documents set lastUpdatedDate = , privateYesNo = , keyWords = , keyWords = ,lastUpdatedBy = , #_f# = , #_f# = where ownerId = and fsl_tablecode = and docId = update tbl_IMG_Images set lastUpdatedDate = , internalOnly = , lastUpdatedBy = , #_f# = , #_f# = where ownerId = and fsl_tablecode = and imgId = update tbl_#_contentDomain#_Repository set updateDate = , updateUserId = , #_f# = , #_f# = where ownerId = and ownerType = and fileId = DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID in (7, 23, 34) select distinct 'GRP' resourceType, g.groupId resourceId, g.ownerId resourceOwnerId, g.fsl_tablecode resourceOwnerType, g.groupName as resourceDescription, rtrim( ltrim( g.groupTypeCd )) as resourceSubType, cast( g.categoryId as int ) as resourceCategoryId, gc.category as resourceCategory from tbl_ORG_AttributeLinks c with (nolock) inner join tbl_SEC_Groups g with (nolock) on g.groupId = c.child_attrId left outer join tbl_SEC_Categories gc with (nolock) on gc.categoryId = g.categoryId and gc.ownerId = g.ownerId and gc.fsl_tablecode = g.fsl_tablecode inner join tbl_ORG_AttributeTypes t with (nolock) on t.attrTypeId = c.child_attrTypeId where c.child_attrTypeID = 23 and c.mstr_attrTypeID = 30 and c.mstr_attrID = and gc.ownerId = and gc.fsl_tablecode = and gc.category = DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 23 and child_attrID in ( ) select distinct 'GRP' resourceType, g.groupId resourceId, g.ownerId resourceOwnerId, g.fsl_tablecode resourceOwnerType, g.groupName as resourceDescription, rtrim( ltrim( g.groupTypeCd )) as resourceSubType, cast( g.categoryId as int ) as resourceCategoryId, gc.category as resourceCategory from tbl_ORG_AttributeLinks c with (nolock) inner join tbl_SEC_Groups g with (nolock) on g.groupId = c.child_attrId left outer join tbl_SEC_Categories gc with (nolock) on gc.categoryId = g.categoryId and gc.ownerId = g.ownerId and gc.fsl_tablecode = g.fsl_tablecode inner join tbl_ORG_AttributeTypes t with (nolock) on t.attrTypeId = c.child_attrTypeId where c.child_attrTypeID = 23 and c.mstr_attrTypeID = 30 and c.mstr_attrID = and gc.ownerId = and gc.fsl_tablecode = and rtrim( ltrim( g.groupTypeCd )) = DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 23 and child_attrID in ( ) DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 23 SELECT child_attrID FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 23 DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 23 AND child_attrID = INSERT INTO tbl_ORG_AttributeLinks (mstr_attrID, mstr_attrTypeID, child_attrTypeID, child_attrID) VALUES(, , , ) select distinct 'USR' resourceType, m.fspro_userId resourceId, m.ownerId resourceOwnerId, m.fsl_tablecode resourceOwnerType, m.email resourceDescription, null as resourceSubType, null as resourceCategoryId, null as resourceCategory from tbl_ORG_AttributeLinks c with (nolock) inner join tbl_fspro_members m with (nolock) on m.fspro_userId = c.child_attrId inner join tbl_ORG_AttributeTypes t on t.attrTypeId = c.child_attrTypeId where c.child_attrTypeID = 34 and c.mstr_attrTypeID = 30 and c.mstr_attrID = and m.ownerId = and m.fsl_tablecode = DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 34 and child_attrID in ( ) select distinct 'USR' resourceType, m.fspro_userId resourceId, m.ownerId resourceOwnerId, m.fsl_tablecode resourceOwnerType, m.email resourceDescription, null as resourceSubType, null as resourceCategoryId, null as resourceCategory from tbl_ORG_AttributeLinks c with (nolock) inner join tbl_fspro_members m with (nolock) on m.fspro_userId = c.child_attrId inner join tbl_ORG_AttributeTypes t on t.attrTypeId = c.child_attrTypeId where c.child_attrTypeID = 34 and c.mstr_attrTypeID = 30 and c.mstr_attrID = and m.fsl_tablecode = DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 34 and child_attrID in ( ) DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 34 and child_attrID not in ( ) SELECT child_attrID FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 34 and child_attrID not in ( ) DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 34 AND child_attrID = INSERT INTO tbl_ORG_AttributeLinks (mstr_attrID, mstr_attrTypeID, child_attrTypeID, child_attrID) VALUES(, , , ) DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 34 and child_attrID not in ( ) SELECT child_attrID FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 34 and child_attrID not in ( ) DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 34 AND child_attrID = INSERT INTO tbl_ORG_AttributeLinks (mstr_attrID, mstr_attrTypeID, child_attrTypeID, child_attrID) VALUES(, , , ) DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 7 SELECT child_attrID FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 7 DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 7 AND child_attrID = INSERT INTO tbl_ORG_AttributeLinks (mstr_attrID, mstr_attrTypeID, child_attrTypeID, child_attrID) VALUES(, , , ) DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 31 SELECT child_attrID FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 31 DELETE FROM tbl_ORG_AttributeLinks WHERE mstr_attrID = AND mstr_attrTypeID = 30 AND child_attrTypeID = 31 AND child_attrID = INSERT INTO tbl_ORG_AttributeLinks (mstr_attrID, mstr_attrTypeID, child_attrTypeID, child_attrID) VALUES(, , , )