T-SQL JSON Join using varchar field

Carlos Barini 21

I need to return three lines:
1- meat / carne
2- meat / boi
3- meat / boi gordo

How can I do that?

Yitzhak Khabinsky 27,091 Reputation points

2021-06-24T18:47:22.18+00:00

@Carlos Barini ,

While asking a question you need to provide a minimal reproducible example:
(1) DDL and sample data population, i.e. CREATE table(s) plus INSERT, T-SQL statements.
(2) What you need to do, i.e. logic, and your attempt implementation of it in T-SQL.
(3) Desired output based on the sample data in the #1 above.
(4) Your SQL Server version (SELECT @@version;)
Carlos Barini 21 Reputation points

2021-06-25T03:18:07.26+00:00

I understand it was enought clear because @Viorel gave us the accepted answer without any doubt. If @Viorel could understand others can.

Tahnk you.
Yitzhak Khabinsky 27,091 Reputation points

2021-06-25T03:46:56.123+00:00

@Carlos Barini ,

You made this post useless for others.
Without a minimal reproducible example, nobody can take Viorel's answer, run it, test it, understand it, and apply it in their environment.

Answer accepted by question author

Viorel 125.8K Reputation points

2021-06-24T13:59:18.257+00:00
Try this query:

select word, [synonym] from adlWordBags cross apply OPENJSON(JSONSynonyms) with ( [synonym] nvarchar(max) '$.word' ) where JSONSynonyms <> ''
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

0 additional answers

Your answer