drew.allen (5/17/2016)
Try changing your CROSS APPLY to an OUTER APPLY. The CROSS APPLY filters out nodes that don't have any instances of the element specified, whereas the OUTER APPLY will leave the nodes that don't have them.If that doesn't fix your problem, then show us the results that you are getting. It really helps to troubleshoot if we know how the expected results differ from the actual results. You have only ever supplied the expected results.
Drew
Hey the outer apply is giving the information i believe i need but i'm still verifying the output.
Sorry about not supplying actual results for i am dealing with sensitive information. And i would need to edit the data returned with dummy information + XML changes.
Sincerely,
Leon CLF
DB Administrator