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'