Category "cross-apply"

How to insert multiple JSON rows into a T-SQL table

I am trying to insert following JSON document into T-SQL: { "GLDETAIL": { "RECORDNO": "264378-1756289-919567--accrual", "BATCH_DATE": "02/01/2

SQL Server - LEFT JOIN two JSON objects on a common property

I have a table with a column holding the schema (key, type) of a JSON object, and another table with a column holding instances of objects described by that sch