I do like the flow.  One thing though - your intro is defining how to *pivot* (how to turn 3 rows into columns), NOT how to un-pivot.  A bit silly...

Could you  provide some sample of what you're expecting?  Some notional test data would be nice as well.

I suspect you don't need the cursor at all and that...

Follow the advice you were given in the OTHER thread, as in, stop using cast to varchar.

These changes worked for me.

drop function dbo.SelectChild

go

CREATE function dbo.SelectChild(@key as bigint)

returns xml

begin

...

Well neither are technically "Microsoft tools", but I've used two different options:

http://json.codeplex.com/%5B/url%5D had a built up C# library to (open source) you can invoke from .NET code to reserialize XML...

Why I understand the intent - is there a requirement to have SQL Server do the JSON serialization? There is a LOT of shareware and/or open source applications that...

Are you sure you actually have parameters? Mark's sample returns an empty result set if there aren't any. My sample didn't have any, but I could pull the...

mark.hanson 1327 (1/3/2017)

I don't think the 300,000.00 is dollars. I suspect it is 300,000 rupee with the employee being a junior and only having a couple of years experience. I...

Jeff Moden (1/3/2017)

It's for a small series of articles I'm working on called "The Devils in the Data". It's about some caveats that a lot of people don't expect...

Hi Jeff -

I went into hibernation for a bit, only to come out and find you dabbling in XML..... Small wonders never cease I guess 🙂

I guess without spilling...