Skip to content

Instantly share code, notes, and snippets.

@bmchild

bmchild/userQuery.sql

Last active August 29, 2015 14:14
Show Gist options
  • Save bmchild/a8dea0eb835c4ae484fd to your computer and use it in GitHub Desktop.
Save bmchild/a8dea0eb835c4ae484fd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
userQuery.sql
select *
from User
where
userId in (:userIds)
-- Then we need an OR clause for each match we want
OR ( lastName = :lastName1 AND SUBSTRING(ssn, LEN(ssn)-3, 4) = :lastFourSsn1)
OR ( lastName = :lastName2 AND SUBSTRING(ssn, LEN(ssn)-3, 4) = :lastFourSsn2)
-- ...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment