peacesells (11/20/2014)
Thanks Eririkur. This certainly gives me a good direction. What if there were multiple secures within a SecurEvent?
Multiple "Secure/SecureType" elements will multiply the outer/parent "SecureEvent" element, as this is an one-to-many relationship. The two most obvious ways of handling this are either to enumerate the outer/parent instances (row_number) or shred the inner element separately in another query.
😎