title: Calculate days remaining using in SQL Server
body: <p>I need a SQL query that would allow me to show how many days are remaining for me to process an invoice, this query should indicate the time remaining to authorize quotes before automatic cancellation which is 14 days for un-processed and 7 days for partially processed. </p>
  
  <p>Can anyone please help me? </p>
  
  <p>Eg. if a quote came in today it should show 14 days, tomorrow 13 days etc. </p>