Skip to content

Instantly share code, notes, and snippets.

@psapir

psapir/gist:895d0b95b8c60073806c4a2d0174feff

Last active August 12, 2016 17:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save psapir/895d0b95b8c60073806c4a2d0174feff to your computer and use it in GitHub Desktop.
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