Troubleshooting
Error 8155
Severity Level 16
Message Text
No column was specified for column %d of ''%.*ls''
Explanation
One or more of the aggregate or computed columns in your select list have not been supplied with an alias.
Action
Supply an alias for all aggregate or computed column. For example:
select pub_name, "count"=count(*)
into #t
from publishers p, titles t
where p.pub_id = t.pub_id
group by pub_name