wvpv/sfmc-sql-split-random-20-percent.sql

Last active January 9, 2023 15:59

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/wvpv/55641d0b258789040fd880dd19e7a8ad.js"></script>
Save wvpv/55641d0b258789040fd880dd19e7a8ad to your computer and use it in GitHub Desktop.

Download ZIP

Raw

sfmc-sql-split-random-20-percent.sql

	select top 20 percent
	de1.field1
	, de1.field2
	from [dataextension1] de1
	order by newid()
	/* writes to DataExtensionSplit_1 */

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment