Quite new to this but i have created a SQL script that groups by and Sums a column.. but in SQL Management studio it shows me a grid with column value but nothing underneath it i.e. the SUM..

Do i have to configure SQL Management studio to show me the SUM or something..

Here is my query its very easy

```
    SELECT  RowNum ,
    ClientName ,
    ( SELECT    SUM(Amount) AS Expr1
    ) AS Amount
    FROM    #TempItems
    GROUP BY RowNum , Amount , ClientName

```

I also changed it to display TextView rather than GRIDVIEW but still no hope.

It displays the Amount column correctly but i don't see any SUM underneath it

Any help really appreciated