Skip to content

Instantly share code, notes, and snippets.

@wvpv

wvpv/sfmc-sql-ranking-method2.sql

Last active December 31, 2018 16:00
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 wvpv/d8415d0011f6b76f865de0cdfd45bb40 to your computer and use it in GitHub Desktop.
Save wvpv/d8415d0011f6b76f865de0cdfd45bb40 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sfmc-sql-ranking-method2.sql
select top 1 with ties
b.bounceCategory
, b.sendid
from _bounce b
order by row_number() over (partition by b.bounceCategory order by newid())
/* list all of the bounce categories and return */
/* a random sendid/jobid associated with each one */
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment