Redirecting you to https://www.red-gate.com/simple-talk/blogs/weighted-randomization-in-t-sql/