4
I’m working with a column of phones, but some lines have two phones separated by ";".
99999999 ; 99999222
12345678 ; 87654321
40028922
123123456 ; 1122334455
My goal is to put duplicate phones on other separate lines.
99999999
99999222
12345678
87654321
40028922
123123456
1122334455
Would have some way to accomplish this with SQL?
What version of SQL Server??
– Oliveira