๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
์นดํ…Œ๊ณ ๋ฆฌ ์—†์Œ

Select SubQuery for Comma Separated Values from Single row

Sorrel_ 2019. 9. 30. 09:14
๋ฐ˜์‘ํ˜•
     SELECT *
     FROM Orders 
      WHERE Status IN (SELECT Value FROM  StatusTable
                         CROSS APPLY STRING_SPLIT(Statuses,','))

https://stackoverflow.com/questions/39643516/select-subquery-for-comma-separated-values-from-single-row

 

Select SubQuery for Comma Separated Values from Single row

From a Select Query I am getting following values in single row , not in different rows: Id Statuses --- ------------- 1 Released,In Progress,Completed Now I want to write a quer...

stackoverflow.com

 

๋ฐ˜์‘ํ˜•
์ €์ž‘์žํ‘œ์‹œ ๋น„์˜๋ฆฌ ๋ณ€๊ฒฝ๊ธˆ์ง€





ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”