I have one string @data it is contained this value
@data=
{
"dcrno": "20",
"doctorcode": "di001",
"salableitems":
[
{
"itemcode":"it0001"
},
{
"itemcode":"it0003"
},
{
"itemcode":"it0002"
}
],
"sample/promo/gift":
[
{
"itemcode": "it001",
"itemqty": 10
},
{
"item code": "it002",
"itemqty": 2
},
{
"item code": "it009",
"itemqty": 7
}
],
"pob": "788",
"not": "rajvalue",
"time": "13:78:90"
}
like
@data='@data=
{
"dcrno": "20",
"doctorcode": "di001",
"salableitems":
[
{
"itemcode":"it0001"
},
{
"itemcode":"it0003"
},
{
"itemcode":"it0002"
}
],
"sample/promo/gift":
[
{
"itemcode": "it001",
"itemqty": 10
},
{
"item code": "it002",
"itemqty": 2
},
{
"item code": "it009",
"itemqty": 7
}
],
"pob": "788",
"not": "rajvalue",
"time": "13:78:90"
}'
now i want to convert into columns
like
dcrno,doctorcode,salable,pob,note,time
like this ..is it possible to convert likt this please help me to do that
What I have tried:
set @data=substring(@data,charindex(':',@data)),len(@data)-1)