select
AttributeName,
AttributeValue,
Value
from dbo.StringMap
where
(dbo.StringMap.AttributeName = 'statuscode'
or
dbo.StringMap.AttributeName = 'statecode')
and
dbo.StringMap.ObjectTypeCode = 1
Will display the following values for the Account Entity ( ObjectTypeCode = 1 ):
AttributeName AttributeValue Value
statecode 0 Active
statecode 1 Inactive
statuscode 1 Active
statuscode 2 Inactive
No comments:
Post a Comment