Skip to content
Advertisement

String Split String With multiple columns same separator

I have the following string

I need to transform it into :

I can use only select statmets, no cursors or SP’s .

Any help please?

Advertisement

Answer

Workaround with STRING_SPLIT(it is not safe):

db<>fiddle demo

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement