title: Select literals as table data in SQL server
body: <p>Consider table Address , with fields Country, State, and other data fields. I want to get all the records except for those with Country,State combination  as (US, IL), (US,LA), (IND,DEL)</p>
  
  <p>The query goes like</p>
  
  <pre><code>Select * from Address a 
  where not exists 
  (
     select Country,State 
     (select 'US' as Country, 'IL' as State 
       union
     select 'US' as Country, 'LA' as State 
       union
      select 'IND' as Country, 'DEL' as State 
    ) e
   where e.Country != a.Country and e.State != a.state
  )
  </code></pre>
  
  <p>How can it be easily achieved (to replace coutry,state combination of union with simple subquery)? As total data is not very large, i am least bothered about performance for now.</p>
  
  <hr>
  
  <p>I know i can create table variable, add all literal combination there using insert into syntax, and use table variable for not exists, but i feel it is overkill for small requirement (not exists on 2 variables).</p>