Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. SELECT *
  2. FROM (SELECT * FROM Customer c WHERE c.Created >= DATEADD(MONTH, -6, GETUTCDATE())) c1
  3. JOIN (SELECT * FROM Customer) c2 ON c1.CustomerID <> c2.CustomerID
  4. WHERE (c1.DOB IS NULL OR c2.DOB IS NULL OR c1.DOB = c2.DOB)
  5. AND DIFFERENCE(c1.FirstName, c2.FirstName) = 4
  6. AND DIFFERENCE(c1.LastName, c2.LastName) = 4
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement