Thanks Matt. Can I request one small help? Below test code has all create table/insert/function and select statement. When I run the select statement, I'm getting escape characters in the...

Our customers are in Oracle and SQL Server 2012. I was asked to create a script to transform data from the tables (which have parent-child relation) to JSON format. I'm...

Please correct me if I'm wrong. Do I need to use RAW mode when using ELEMENTS XSINIL? In this case a new subelement is created. I might not need a...

I'm very sorry for all the confusion I might have created. My original thread: 'Hierarchical XML data to JSON' is still unanswered. I have been trying other ways to get...

I'm still stuck with the issue. Any help is greatly appreciated.

My goal is to create a JSON format from the output.

In the other thread I mentioned, I'm not getting any error. I'm unable to produce the data as JSON. The sample data I provided in the thread might help you...

Thanks Sean.. I'm not worried about this issue but my main concern is in below thread.

Could you please suggest on how to convert Hierarchical XML data to JSON. I provided...

Thanks Drew for your reply. I edited my original post. Could you please retry?

I'm getting below error (sorry for the misleading title):

Maximum stored procedure, function, trigger, or view...

Thanks a lot for your reply.

I'm trying to create JSON data.

Related to the same topic, could you please also refer to my other post: Hierarchical XML data to...