Greetings all, I'm trying to play around with XML and write a fairly basic query. I want the following query to return "SeatThree" but when I try to create the xml document first I get the error "XML parsing: line 14, character 6, unexpected end of input" I've tried to look up the error, with minimal success. Any help would be appreciated, or a point in the right direction. Is there something wrong with my code? Am I missing something major? Thanks again...
DECLARE @abc AS XML;
I would use this Xquery code to try to return "SeatThree"
SELECT @abc.query('data(usa/or/portland/southeast/hawthorn/37ave/BagdadTheater)') AS Element_theaterseat_data