In that earlier column, I looked at why you might want to do that and handled the simple case: Converting single-value properties in a JSON object into a row in a table (or multiple rows where you ...

In a previous TechRepublic column about SQL Server 2005, I showed how you can convert some of your iterative ... you need to individually handle each row in a result set. SQL Server 2008 provides ...