title: SQL Server partitioned view key
body: <p>I have a partitioned view with 20 tables. Each table has a partition key (usp_id) ranging from 1 to 20. If I query the partitioned view using the partition key then only the table with the correct usp_id is queried which is fine.</p>
  
  <p>Now i have a second table which has two fields. Usp_id and insert_date. The insert_date in this table is updated daily. It is a one to one mapping in this table.</p>
  
  <p>I would like to be able to query my partition view based on insert_date which then would use the usp_id to query the partitioned view.</p>
  
  <p>Is this possible?</p>
  
  <p>Many thanks in advance!</p>