title: SQL query returning values not existing in table from set in (brackets)
body: <p>Need to get values which are not in table, enumerated right in TSQL query</p>
  
  <p>Table Cities</p>
  
  <p><code>create table Cities (Id int, City nvarchar (max))
  insert into Cities values 
  (1, 'New York'),
  (2, 'Moscow'),
  (3, 'Mexico'),
  (4, 'Kuala-Lampur')</code></p>
  
  <p>Now I need to extract cities that exist in set 
  ('Los Angeles', 'Moscow', 'Oslo') but not exist in Cities table.
  So I need result:</p>
  
  <ul>
  <li>Los Angeles</li>
  <li>Olso</li>
  </ul>
  
  <p>I know the easiest way is to use temp table like</p>
  
  <pre><code>declare @temp table (City nvarchar (max))
  insert into @temp values
  (Los Angeles),
  (Moscow),
  (Oslo)
  
  Select City from @temp
  where City not in (Select City from Cities)
  </code></pre>
  
  <p>But may be there is a way to avoid temp table?</p>