All Questions
Tagged with open-json cross-apply
5
questions
1
vote
1
answer
552
views
count values in json array per ID on multiple rows w/ OPENJSON
I have a table containing Id and JsonData columns (table has 100's of rows)
JsonData contains an array with various contact ID's for each Id
{"contacts":[{"id":"7d18e3c1-6849-...
0
votes
1
answer
1k
views
Extract values from an SQL column with JSON format
I need to extract values from a column which has a JSON format.
Here is an example of one of rows in table for this column, here is two operatorKeys but in other rows there might be more:
{
"...
2
votes
1
answer
73
views
How to get complex JSON string into columns SQL Server
I have stored some data in the table as JSON string like below.
[
{
"firstName":"John",
"lastName":"Smith",
"age":25,
"...
1
vote
1
answer
1k
views
how to measure length of array inside array in json file using SQL OPENJSON function with cross APPLY
"table": [
{
"name": "Emergency",
"columns": [
{
...
0
votes
1
answer
2k
views
how to add key-value pair in json root node and convert it into table using SQL server
I have table people and it's maintain Four column which is Name ,TagName ,Value , Location.
I want to convert the tagname and value in json with name and location column as rootnode (Name & ...