title: WTH (NOLOCK) syntax fo subquery
body: <p>I am trying to add with (nolock) in a report query that when run locks the full db making imposssible for other users to use the db.</p>
  
  <p>I can't figure out how to use in this case:</p>
  
  <pre><code>-- this is just an example:
  SELECT FIELDS FROM (SELECT * FROM ATABLE) AS SUB
  </code></pre>
  
  <p>This gives syntax error:</p>
  
  <pre><code>SELECT FIELDS FROM (SELECT * FROM ATABLE) WITH (NOLOCK) AS SUB
  </code></pre>
  
  <p>where <code>WITH (NOLOCK)</code> shuold be put?</p>
  
  <p>I am not saying this is a solution to all problems, it is just a test i want to.</p>
  
  <p>Thanks!</p>