USE CRM_MSCRM GO
SELECT
sm.AttributeValue
,sm.Value
FROM StringMap sm with(nolock)
inner join EntityLogicalView el with(nolock) on
sm.ObjectTypeCode = el.ObjectTypeCode
WHERE
AttributeName = 'statuscode'
AND LangId = 1033
AND el.Name = 'Opportunity'
GO

No comments:
Post a Comment