declare @EntityName varchar(100) set @EntityName = 'IncidentResolution' select s.* from <<yourCRMdatabase>>..stringmap s where s.objecttypecode in (select objecttypecode from <<yourCRMMETABASEdatabase>>..entity where name = @EntityName)