title: sql query result returns asterisk "*" as column value
body: <p>I'm trying to update a temporary table with multiple values from another table without using a join. 
  However, the query doesn't give any error but rather returns an asterisk as the value of the column. I have googled and asked some folks around the office but no one seems to have encountered this before or can offer explanation of why this could be happening. </p>
  
  <pre><code>update ##tempCLUnique set Total = 
  (
      select COUNT(distinct u.unique_subs)
      from tbl_Cluster_Cumm_Unique_Subs u
      where u.cluster = ##tempCLUnique.cluster
  )
  </code></pre>
  
  <p>Seems simple enough </p>
  
  <p><a href="http://i.stack.imgur.com/qE0ER.png" rel="nofollow">Result Screen Grab</a><a href="http://i.stack.imgur.com/qE0ER.png" rel="nofollow">http://i.stack.imgur.com/qE0ER.png</a></p>