By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Trees
(
[Id] INT,
[Type] NVARCHAR(100),
[Height] DECIMAL(2,1)
);
CREATE TABLE TreesGrowthLog
(
[Day] DATETIME,
[TreesGrowth] NVARCHAR(MAX)
);
INSERT INTO Trees ([Id], [Type], [Height])
VALUES
(1, 'Palm', 5.5),
(2, 'Pine', 6.2),
(3, 'Apple', 2.5),
(4, 'Japanese Cedar', 0.5),
(5, 'Spanish Fir', 0.6);
5 rows affected
SELECT * FROM (
SELECT
highTrees = JSON_QUERY(
(
SELECT
Id as id,
Type as type,
Height as height
FROM Trees WHERE [Height] > 5
FOR JSON PATH
)
),
lowTrees = JSON_QUERY(
(
SELECT
Id as id,
Type as type,
Height as height
FROM Trees WHERE [Height] < 1
FOR JSON PATH
)
)
FOR JSON
PATH, WITHOUT_ARRAY_WRAPPER
) TreesJson;
Msg 8155 Level 16 State 2 Line 26
No column name was specified for column 1 of 'TreesJson'.
INSERT INTO TreesGrowthLog ([Day],[TreesGrowth])
VALUES (CAST(GETDATE() AS Date), (SELECT * FROM TreesJson FOR JSON AUTO))
Msg 208 Level 16 State 1 Line 1
Invalid object name 'TreesJson'.