Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@wvpv

wvpv/sfmc-sargable-where-clause-comparison.sql

Last active October 2, 2018 19:31
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/8db55db35239cea0870347b86d590661 to your computer and use it in GitHub Desktop.
Save wvpv/8db55db35239cea0870347b86d590661 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sfmc-sargable-where-clause-comparison.sql
/* do not do this */
select
o.subscriberkey
from _open o
where
cast(o.eventdate as date) = convert(date, getDate()-1)
and o.isunique = 1
/* do this instead */
select
o.subscriberkey
from _open o
where
o.eventdate >= convert(date, getDate()-1)
and o.eventdate < convert(date, getDate())
and o.isunique = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment