When trying to import shared definitions from a XML Schema, I can properly reference shared types, but referencing shared elements causes validation errors.
I have imported an xml document into SQL Server, I am now trying to import various parts into different tables. When I use the below query it only returns one row of hotel_facilities, I need to return