GROUP-BY expression must contain at least one column that is not an outer reference

Question

i have this query:

SELECT
SolutionName    -- Solution_NAM
from  Table_View
Group By 1

where Table_View is of course a view. I am gettign this error message:

Each GROUP BY expression must contain at least one column that is not an outer reference.

Can you help me resolve this? It´s inside Ms SQL Server 2008

Solution

you cannot give Group by 1

try

SELECT
SolutionName    -- Solution_NAM
from  Table_View
Group By SolutionName