title: SQL Query Error - Error Source: .Net SqlClient Data Provider
body: <pre><code>Error Message: The SELECT permissions was denied on the object 'quote', database 'oneview', schema 'dbo'.
  </code></pre>
  
  <p>I am relatively new to SQL and the developer I am learning from is only part time and very hard to get a hold of unfortunately. Can anyone help me understand what is wrong with the Query below and suggest any fixes that might be needed?</p>
  
  <pre><code>SELECT     licenseEntitlement.entID, licenseEntitlement.entStartDate, licenseEntitlement.entEndDate, quote.quoteId, quote.accountId, quote.clientId, 
                        quote.clientName, quote.contactName, quote.contactEmail, quote.extReference, quote.purchaseOrderNumber, quote.linkedTicket
  FROM         licenseEntitlement INNER JOIN
                        quote ON quote.quoteId = SUBSTRING(licenseEntitlement.entComments, 12, PATINDEX('% Created%', licenseEntitlement.entComments) - 12)
  WHERE     (licenseEntitlement.entType = 'AVS') AND (licenseEntitlement.entComments LIKE 'OV Order + %') AND (licenseEntitlement.entEndDate &lt; '7/1/2014')
  ORDER BY licenseEntitlement.entEndDate
  </code></pre>