Get the mentioned output by SQL query

by

You can use below query . String split works on SQL server 2016 and later versions.

 Select * into #temp 
    from #location l 
    join (
    select item,value  from #item
     CROSS APPLY STRING_SPLIT(location_id, ',')
        ) A on l.id=a.value


     select
        item, 
        stuff((
            select ',' + u.city
            from #temp u
            where u.item = A.item
            for xml path('')
        ),1,1,'') as List
    from #temp A
    group 

by item
Drop table #temp

More Related Contents:

  1. How to concatenate text from multiple rows into a single text string in SQL Server
  2. How to SELECT FROM stored procedure
  3. What’s the best practice for primary keys in tables? [closed]
  4. Avoid duplicates in INSERT INTO SELECT query in SQL Server
  5. How do you list the primary key of a SQL Server table?
  6. Calculating distance between two points (Latitude, Longitude)
  7. SQL Server check case-sensitivity?
  8. Multiplication aggregate operator in SQL
  9. How to update Identity Column in SQL Server?
  10. SQL Server: Get table primary key using sql query [duplicate]
  11. How to determine the number of days in a month in SQL Server?
  12. Concatenate values based on ID
  13. Finding duplicate rows in SQL Server
  14. Why and when a LEFT JOIN with condition in WHERE clause is not equivalent to the same LEFT JOIN in ON? [duplicate]
  15. Detect consecutive dates ranges using SQL
  16. how to declare global variable in SQL Server..?
  17. Scope of temporary tables in SQL Server
  18. Convert text value in SQL Server from UTF8 to ISO 8859-1
  19. Split values over multiple rows [duplicate]
  20. Must declare the scalar variable
  21. Can an INNER JOIN offer better performance than EXISTS
  22. Why does SQL Server round off results of dividing two integers?
  23. How to Map Input and Output Columns dynamically in SSIS?
  24. Find the real column name of an alias used in a view?
  25. How to get the identity of an inserted row?
  26. SQL Server: should I use information_schema tables over sys tables?
  27. How to create a pivot query in sql server without aggregate function
  28. Finding a Top Level Parent in SQL
  29. SQL Server Cumulative Sum by Group
  30. SQL Server FOR XML Path make repeating nodes

Leave a Comment