psapir/gist:895d0b95b8c60073806c4a2d0174feff

Last active August 12, 2016 17:32

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/psapir/895d0b95b8c60073806c4a2d0174feff.js"></script>
Save psapir/895d0b95b8c60073806c4a2d0174feff to your computer and use it in GitHub Desktop.

Download ZIP

Distributing Rows Equally with Query Activities

Raw

gistfile1.txt

	SELECT FirstName, EmailAddress, NTILE(3) OVER(ORDER BY NewID() DESC) AS groupID
	FROM Subscribers

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