Hi, I have a requirement to insert values into table. I have to create stored procedure. This SP is part of API, when a user "Save" data on UI, this API will call and execute this SP. Below if json format, i get from UI. Below JSON should go into these tables..
Create table dbo.test (Quarter,Entity,Schooldetails,Teachername,Teachid,Observation)
Create table dbo.test1 (username,Age,Id,CtrName,Rank,Levelid,business) - two records will be inserted
"Easy" : {
"Quarter": "2nd Q"
"Entity": "ABC"
"Schooldetails": [{
"Username": "Dinesh,K",
"Age": "45",
"Id": "1"
}, {
"Username": "Dinesh,K",
"Age": "45",
"Id": "1"
}
],
"Teachername": "Suni",
"Teachid" : "123",
"Additionalinfo":[{
"CtrName": "test1",
"Rank": "1",
"Levelid": "lvl1",
"business": "forest"
},{
"CtrName": "test2",
"Rank": "2",
"Levelid": "lvl2",
"business": "air"
}
],
"Observation": "1"
}