INSERT INTO EMAILS(emails)
SELECT A.value AS EMAIL_QUEBRADO
FROM EMAIL X
OUTER APPLY STRING_SPLIT(X.email, ',') AS A