delete from tbl_OPR_CustAttrbLnks where categoryId = 58 and attributeId = 482 update tbl_OPR_ClientOperators set lrwMaterial = null where ownerId = 99 and fsltablecode = 'MSC' update lnk set lnk.groupId = 5311 from tbl_SEC_MemGrpLink lnk where lnk.GroupID = 5851 and lnk.FSPro_UserID in ( select mem.fspro_userId from tbl_FSPro_Members mem with (nolock) where mem.OwnerID = 99 and mem.FSL_TableCode = 'MSC' )