title: Query for match all records in list SQL Server
body: <p>I have a table bawe_services. i want to fetch all data that match with given keys</p>
  
  <p>like i have fields</p>
  
  <pre><code>id  | Service_id |bawe_id
  1       2          2
  2       3          3
  3       2          3
  </code></pre>
  
  <p>if i pass service =2 i need all record of service_id=2 if i pass service=1,2,3 than i want 0 rows because 1 service is not given by any bawe so. i got 0 rows.</p>
  
  <p>I use this query </p>
  
  <pre><code>select * from aspnet_bawe_services where ser_id in(1,2,3)
  </code></pre>
  
  <p>Thanx in advance</p>