Sql How To Loop Through Split String

Summary

SQL : How to loop through split string ... Documentation: docs.microsoft.com/en-us/ sqlinterviewquestions input:- ID_name ID a-b-c 1 d-e-f 2 g-h-i 3 Output :- value ID a 1 b 1 c 1 d 2 e 2 f 2 g 3 h 3 i 3. This video explains the use of CharIndex function ... here- learn.microsoft.com/en-us/ This was a fun afternoon I spent getting this working nicely. I don't know if there are better ways of doing this, but if there are then ... DECLARE nvarchar(max) DECLARE int DECLARE int SET SET ... NOTE: We now have an updated version of this tool. See youtu.be/aLeLNVVpYZM. SDU Tools are a free set of T-