Category "xmlnode"

Read attribute from XML in SSMS using XML.Node

I'm trying to read an XML file, the aim is to get ddscontrol to return 888 in one record and 999 in the other. Similarly for tooltip I need to return TTT111