CODEWITHSUNDEEP
sqlt-sql
Clifford Pabs-Garnon
Clifford Pabs-Garnon

Reputation: 97

sql query result returns asterisk "*" as column value

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. 

update ##tempCLUnique set Total = 
(
    select COUNT(distinct u.unique_subs)
    from tbl_Cluster_Cumm_Unique_Subs u
    where u.cluster = ##tempCLUnique.cluster
)

Seems simple enough

Result Screen Grabhttps://i.sstatic.net/qE0ER.png

Upvotes: 4

Views: 4152

Answers (1)

Ashutosh Arya
Ashutosh Arya

Reputation: 1168

Use this 

update ##tempCLUnique set Total = U.unique_subs

FROM ##tempCLUnique
INNER JOIN
(
    select COUNT(distinct unique_subs)unique_subs
    from tbl_Cluster_Cumm_Unique_Subs 

)U

ON

 u.cluster = ##tempCLUnique.cluster

Change the join according to your use.

Ashutosh

Upvotes: 1

Related Questions