I need to read the XML below with a select statement so I can manipulate and read into a SQL Table.
In the image below the selct statement would repeat the packtNum and RunDate every line
The items in the repeating <Record> tags would each have its own record line and a column for each tag..example
packtNum RunDate SeqNumber LienRefNum, blah...blah...blah...First
Name MiddleInit LastName RejectReason