SELECT [D].[CRMSMBOpportunityKey] , [A].[CreatedOn] , [B].[Value] , [B].[AttributeName] INTO [Tmp].[LeadAuditHistory_Days] FROM [SMBBI_DataSources].[GMODW_DS].[AuditBase] [A] WITH (NOLOCK) INNER JOIN [SMBBI_DataSources].[GMODW_DS].[FilteredStringMap] [B] WITH (NOLOCK) ON CAST([A].[ChangeData] as NVARCHAR(255)) LIKE '%' + CAST([B].[AttributeValue] AS NVARCHAR(255)) + '%' AND [B].[AttributeName] = 'new_salesstage' INNER JOIN [SMBBI_DataSources].[GMODW].[DimOpportunityCRMSMB] [D] WITH (NOLOCK) ON [A].[ObjectID] = [D].[OpportunityID] AND [D].[IsCurrent] = 1
[B].[AttributeValue]
LIKE
[A].[ChangeData]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)