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 = INSERT INTO tbl_FSC_Content(MainFolder,SubFolder,FileName) VALUES (, , ); SELECT imageId = @@IDENTITY UPDATE tbl_FSPro_Members SET ImageID = WHERE FSPro_UserID = AND OwnerID = AND FSL_TableCode = ; UPDATE tbl_FSC_Content SET FileName = WHERE ContentID =