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