select ownerid, fsl_tablecode as ownertype, staffmember, imageid, fspro_userid, 'STF'+ CAST(fspro_userid as varchar) + ' ' + firstname + ' ' + lastname as subjectDescription from tbl_fspro_members with (nolock) where fspro_userid = select fsc.ContentID, fsc.MainFolder, fsc.SubFolder, fsc.FileName from tbl_FSPro_Members mems with (nolock) inner join tbl_FSC_Content fsc with (nolock) on fsc.ContentID = mems.ImageID where mems.OwnerID = and mems.FSL_TableCode = and mems.FSPro_UserID = delete from tbl_FSC_Content where contentid = and contentId <> 755 UPDATE tbl_FSPro_Members SET ImageID = 755 WHERE FSPro_UserID = AND OwnerID = AND FSL_TableCode =