how can I assign a column name to the SUM column ?
i.e.
select OwnerUserId, SUM(PostScore)
INTO Experts
from ...
I get this error:
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
I guess because the column containing the results of SUM has not name.
See Question&Answers more detail:os