Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "PartnerName": null,
- "PartnerCurrencyCode": "UAD",
- "PricingConditions": [
- {
- "PricingConditionId": 659853,
- "ConditionTypeCode": "ABCD",
- "ConcessionItemTypeCode": "ABC",
- "PriceLevel": null
- }
- ],
- "CurrencyMultiplier": 0
- }
- PartnerName PartnerCode PartnerCurrencyCode PricingConditionId
- NULL NULL UAD 659853
- SELECT * FROM OPENJSON(@json, '$')
- SELECT *
- FROM OPENJSON(@json)
- WITH (PartnerName NVARCHAR(50) '$.PartnerName',
- PartnerCode nvarchar(50) '$.PartnerCode',
- PartnerCurrencyCode nvarchar(50) '$.PartnerCurrencyCode',
- PricingConditionId nvarchar(50) '$.PricingConditions.PricingConditionId')
- PartnerName PartnerCode PartnerCurrencyCode PricingConditionId
- NULL NULL UAD NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement