daily pastebin goal
7%
SHARE
TWEET

Untitled

a guest Dec 19th, 2018 57 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DECLARE
  2.     @name NVARCHAR(100) = 'Brian',
  3.     @mobile NVARCHAR(100) = '0219002315'
  4. SELECT cd.CustomerID FROM [dbo].[BDB_CustomerDetails] cd
  5.  where (cd.MetaKey='First Name' AND cd.MetaValue=@name )
  6.    or (cd.MetaKey='Mobile' AND cd.MetaValue=@mobile)
  7. group by cd.CustomerID
  8. having count(*) = 2
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top