title: Need a gap query to check for gap in daily price data
body: <p>I have the below data for 2 Securities as illustration, there are 2 tables where i want to check gaps</p>
  
  <p>Price Table --- Time Series Format only Weekdays data</p>
  
  <pre><code>Sec ID    Date       Price
  1       01-Jan-2014  10
  1       02-Jan-2014  --- gap in price record not exist in price table
  1       03-Jan-2014  --- gap in price record not exist in price table
  1       04-Jan-2014  Saturday 
  1       05-Jan-2014  Sunday
  1       06-Jan-2014  --- gap in price record not exist in price table
  1       07-Jan-2014  11
  </code></pre>
  
  <p>Output Needed gap in Price from 02-Jan till 06-Jan-2014</p>
  
  <p>Shares Table --- Data stored in HOC Format</p>
  
  <pre><code>Sec ID      Start        End          Shares
  1          01-Jan-2013  31-Dec-2013    100
  1          07-Jan-2014  31-Jan-2014    105
  </code></pre>
  
  <p>Output needed gap in shares from 01-Jan-2014 till 06-Jan-2014 (weekend should be included)</p>
  
  <p>I have calendar Table available with me which has all weekdays and excluded weekend</p>
  
  <p>Please advise for efficent query</p>
  
  <p>Thanks
  Hitesh</p>