Untitled

Insert into #TEST_TABLE
select distinct 81, 'de56fa43-838d-46d7-a86f-214cda649013', 'metadata', R.[elementName],
Json_Value(@VEJSONDATA,R.[jsonNode]),
'I',GETDATE(),GETDATE(),GETDATE() 
from openjson(
	(
	select SubjobMap
	from
	FileType_subjob_map
	where Subjobtypeid=7
	),
	'$.VeJsonProperties'
) as O
CROSS APPLY OPENJSON(O.[value])
WITH
(
[elementName] NVARCHAR(100) '$.elementName',
[jsonNode]  NVARCHAR(max) 
)
AS R;