Viewing 15 posts - 1 through 15 (of 37 total)
Thanks Phil. Yeah I saw that article and tried cmd.Parameters.Clear but to no avail.
June 17, 2022 at 2:48 pm
its the latest version 18.1 of SSMS im running and this was installed on my local windows ...on my hard drive and not in docker
Now I did look at the...
June 10, 2022 at 3:29 pm
Ok adapting Steve's code, I have managed to solve this:
My code as follows:
INSERT INTO [dbo].[ReturnItemsCalibration_Points] ([ReturnItemsCalibration_ChannelsID],[Points])
SELECT
RICC.ReturnItemsCalibration_ChannelsID,
jkvp.[Value] as Points
FROM
-- RETURNS
OPENJSON(@json)
WITH
(
-- Return
id INT '$.return.d3r_id'
) [returns]
CROSS APPLY
-- ITEMS
OPENJSON(@json, '$.return.items')
WITH
(
[name] NVARCHAR(30) ,
part_number NVARCHAR(30) ,
serial_number...
April 21, 2022 at 3:16 pm
Hi Steve
thanks for that .
i tried to adapt your code as follows but it didnt work
SELECT
ri.ReturnItemsID
, ROW_NUMBER() OVER (
PARTITION BY [returns].id,cal_channels.serial_number
ORDER BY [returns].id,cal_channels.serial_number
) RowNo
-- CALLIBRATION CHANNELS
,calc_chan_detail.channel
,calc_chan_detail.name
,calc_chan_detail.UNIT
,[calc_chan_ponts].*
--INTO [ReturnItemsCalibration_Channels]
FROM
-- RETURNS
OPENJSON(@json)
WITH
(
-- Return
id INT...
April 21, 2022 at 1:30 pm
Hi Phil
Briliiant thank you very much that helps me dig into the hierarchy
Now from what I understand, you declare each section of the JSON you want to access
like this:
items NVARCHAR(MAX)...
March 22, 2022 at 11:48 am
Hi Brian
OK ...here is my sample JSON
DECLARE @json NVARCHAR(MAX);
SET @json = N'
{
"return": {
"d3r_id": "4723",
"reference":"ccRET28092107",
"po": "4500478023",
"customer_reference": "",
"type": "Calibration",
"notes": "",
"status": "In Transit",
"eori": false,
"sent_to_salesforce": "2021-09-28 18:03:01",
"items": [
{
"name": "TK-0014",
"part_number": null,
"serial_number": "305202",
"calibration_type": "Custom",
"calibration_notes": "20\u00b0C and...
March 22, 2022 at 1:11 am
attached is the source JSON file
March 21, 2022 at 6:46 pm
Hi Ratpak
Yes I tried those commands and both return results correctly as shown in the screenshot
March 15, 2022 at 8:52 pm
Hi Eddie
I tried adding the schema dbo in . My defaut schema is set to dbo.
However it didnt recognise that . Please see attached screeenshot
March 15, 2022 at 5:29 pm
Thanks Phil. I will download SSDT and give that a try
March 15, 2022 at 2:10 pm
Hi jeff
Thats a very elegant solution .. thank you very much for that
February 22, 2022 at 11:26 am
Hi Ratnbak
no there shouldnt be a space after the comma...that was a typo!
February 21, 2022 at 5:13 pm
Thanks Kaj...that worked very well for me
February 21, 2022 at 5:13 pm
Hi Phil
Brilliant. That works very well. Thank you very much for your help
December 7, 2021 at 11:43 am
December 6, 2021 at 8:26 pm
Viewing 15 posts - 1 through 15 (of 37 total)