SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT DISTINCT T.CompanyID FROM #Targetlist AS T INNER JOIN new.CompanyIndex AS CI2 WITH (NOLOCK) ON [T].[CompanyID] = CI2.CompanyID WHERE [CriteriaID] = @CriteriaID AND ( @includeNonMain = 1 OR isMain = 1 ) AND [SegmentNo] = @SegmentNo ) AS CI ON UD.[CompanyID] = CI.CompanyID WHERE UD.[LocalIdentifierID] = @LocalIdentifierID AND [UD].[IsActive] = 1 ORDER BY UD.[CompanyID]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)