Home Forums SQL Server 2019 SQL Server 2019 - Development DBA Challenge! I've spent 4 hours trying to figure how to extract data from XML in a hierarchical form. RE: DBA Challenge! I've spent 4 hours trying to figure how to extract data from XML in a hierarchical form.

  • Patrick - just to be extra clear - can you model up/dummy up what it is you're expecting to get back? Are you essentially trying to just return XML snippets as XML based on the bigger document?

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?