Skip to content

Instantly share code, notes, and snippets.

@davidclarance

davidclarance/stable_randomization_tsql.sql

Created July 29, 2024 11:03
Show Gist options
  • Save davidclarance/99a22cc90bd7172fc2a2d00745b62c0e to your computer and use it in GitHub Desktop.
Save davidclarance/99a22cc90bd7172fc2a2d00745b62c0e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
stable_randomization_tsql.sql
WITH customers AS (
SELECT 'Customer1' AS customer_id UNION ALL
SELECT 'Customer2' AS customer_id UNION ALL
SELECT 'Customer3' AS customer_id UNION ALL
SELECT 'Customer4' AS customer_id
)
SELECT
c.customer_id,
CONVERT(BIGINT, SUBSTRING(HASHBYTES('MD5', c.customer_id), 1, 5)) % 100 AS assigned_bucket
FROM customers c;
@davidclarance
Copy link
Author

You can see the python version here: https://gist.github.com/davidclarance/daeafad5fc3e28e019950a12b0da01f5

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