By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE @json NVARCHAR(MAX);
SET @json = '{
"orderId": 431,
"openTime": "2022-10-31T13:12:28",
"closeTime": "2022-10-31T13:12:32",
"operatorId": 7,
"terminalId": 4,
"sessionId": 1,
"products": [
{
"productId": 2632,
"productGroupId": 162,
"quantity": 1,
"taxValue": 0.58,
"value": 3.5,
"priceBandId": 2
},
{
"productId": 3224,
"productGroupId": 164,
"quantity": 1,
"taxValue": 0.08,
"value": 0.5,
"priceBandId": 2
}
],
"tenders": [
{
"tenderId": 2,
"value": 4.0
}
],
"type": 1,
"memberId": 1
}
';
| orderId | openTime | closeTime | operatorId | terminalId | sessionId | productGroupId | productId | quantity | taxValue | value | priceBandId | DateUpdated |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 431 | 2022-10-31 | 2022-10-31 | 7 | 4 | 1 | 162 | 2632 | 1 | 0.58 | 3.5 | 2 | 2024-10-14 06:25:59.403 |
| 431 | 2022-10-31 | 2022-10-31 | 7 | 4 | 1 | 164 | 3224 | 1 | 0.08 | 0.5 | 2 | 2024-10-14 06:25:59.403 |