SQL to JSON – array of objects to array of values in SQL 2016

by

Thanks! The soultion we found is converting into XML first – 

SELECT  
JSON_QUERY('[' + STUFF(( SELECT ',' + '"' + item_id + '"' 
FROM #temp FOR XML PATH('')),1,1,'') + ']' ) ids  
FOR JSON PATH , WITHOUT_ARRAY_WRAPPER

More Related Contents:

  1. How do I query using fields inside the new PostgreSQL JSON datatype?
  2. Index for finding an element in a JSON array
  3. Query for array elements inside JSON type
  4. How can I import a JSON file into PostgreSQL?
  5. Is there a LastIndexOf in SQL Server?
  6. Return multiple columns of the same row as JSON array of objects
  7. SQL Server SELECT to JSON function
  8. When can I save JSON or XML data in an SQL Table
  9. Query for element of array in JSON column
  10. Generate nested nth level JSON SQL Server using recursive CTE
  11. Query json dictionary data in SQL
  12. PostgreSQL Index on JSON
  13. How to search SQL column containing JSON array
  14. Operator does not exist: json = json
  15. How can I work with SQL NULL values and JSON in a good way?
  16. Current date in Oracle Db
  17. How do I UPDATE from a SELECT in SQL Server?
  18. Optimize GROUP BY query to retrieve latest row per user
  19. INNER JOIN vs LEFT JOIN performance in SQL Server
  20. Function vs. Stored Procedure in SQL Server
  21. Check if value exists in Postgres array
  22. Finding duplicate rows in SQL Server
  23. Is there common street addresses database design for all addresses of the world? [closed]
  24. How to use ASP variables in SQL statement
  25. Split values over multiple rows [duplicate]
  26. SQL Server: should I use information_schema tables over sys tables?
  27. SQL Server Cumulative Sum by Group
  28. How to handle optional parameters in SQL query?
  29. SQL Server SELECT INTO @variable?
  30. Select a column if other column is null

Leave a Comment