CROSS APPLY T.Y.nodes('dataset/record') AS MY_XML(record); SELECT * FROM update_table as b cross apply Employees SELECT * FROM ...

you can read it into a table and then query it. This syntax creates a new table in SQL Server and loads your trace file into it ...

This screenshot lists the source of a SQL Server ... data types haven’t been altered). Finally, this snippet of working source illustrates how easy it is to INSERT XML data into temp tables ...