Instantly share code, notes, and snippets.

Embed
What would you like to do?
select top 25 percent
de1.*
from [dataextension1] de1
left join [dataextensionsplit_1] split1 on (de1.[email address] = split1.[email address])
where split1.[email address] is null
order by newid()
/* writes to dataextensionsplit_2 */
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment