I am new in XML SQl i have created a schema with namespace in SQL 2005; I can return single records with the following query using table and column name; however, i do not understand how to return multiple (nodes) records from xml segments where there are
multiple (same) elements.
Here is the query which works with one record, when trying to declare the Namespace to use nodes get error
The schema is an HIPAA 837 schema with multiple elements ; Table name =
PATIENTTRAC_SUBMISSION_HISTORY; xml field = PATIENTTRAC_EDI_SUBMISSION