@MichaelGreen blast from the past but if it's something you still care about i have a reasonable facsimile of json .GetParent for SQL Server use dbfiddle.uk/…
still tinkering with it this evening but i've been known to tinker things to death and wanted to share it here before i forget for another month (or forever)
@EvanCarroll Very nice - I'm busy today, so unfortunately I can't subject your solution to my separate-the-men-from-the-boys, white-hot cauldron of my testing! :-) I shall publish my considered opinion later in the week!
One thing though; I would suggest that you get professional help for that timid, bashful, almost painful, shyness of yours - you're hiding your light under a bushel to the detriment of all of humanity!
