SELECT distinct so.[SmartObjectGUID]
,so.[DisplayName_XML]
--,so.[SmartObjectXML]
--,so.[SystemName]
,so.SmartObjectXML.value('(//serviceinstance/@name)[1]','nvarchar(MAX)') ServiceInstanceName
,so.SmartObjectXML.value('(//serviceinstance/objects/object/@name)[1]','nvarchar(MAX)') ServInstObjectName
,sx.ServiceObjectXML.value('(/object/metadata/display/displayname)[1]','nvarchar(MAX)') SqlName
,sx.ServiceObjectXML.value('(/object/@type)[1]','nvarchar(MAX)') SqlTypeName
--,sx.ServiceObjectXML
FROM [K2].[SmartBroker].[SmartObject] so
left outer join [SmartBroker].[ServiceObject] sx on sx.SystemName = so.SmartObjectXML.value('(//serviceinstance/objects/object/@name)[1]','nvarchar(MAX)')
and sx.SystemName is not null
where
so.SmartObjectXML.value('(//serviceinstance/@name)[1]','nvarchar(MAX)') = 'TestDataDb'
Comments
0 B
|👍
/👎
0 B
|👍
/👎