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