Get Total in a single line in SQL Server

Question

I have a very simple SQL Query which is getting results in the following way

COLUMN A COL-B

WINDCHILL   99.998889 
WINDCHILL   96.000000

Now how i can modify my query so that I get the total in a single line?
COL-A COL-B

WINDCHILL   195.99 

The necessary query is as;

 SELECT 
       ISNULL([Task IT Assets], [Project IT Asset]) AS Asset ,
       SUM(P.ActualWork) AS taskHours
 FROM
      [IR.TimesheetHoursProjectTask] p 
 WHERE
      p.ActualWork > 0 AND 
      ([Task IT Assets] IS NOT NULL OR [Project IT Asset] IS NOT NULL) 
 GROUP BY 
      ISNULL([Task IT Assets], [Project IT Asset]), ActualWork 
 ORDER BY
      p.ActualWork DESC 

Answer 1

You need to modify the GROUP BY and the ORDER BY clauses.

Try this:

SELECT 
       ISNULL([Task IT Assets], [Project IT Asset]) AS Asset ,
       SUM(P.ActualWork) AS taskHours
 FROM
      IR.TimesheetHoursProjectTask p 
 WHERE
      p.ActualWork > 0 AND 
      ([Task IT Assets] IS NOT NULL OR [Project IT Asset] IS NOT NULL) 
 GROUP BY 
      ISNULL([Task IT Assets], [Project IT Asset]) 
 ORDER BY
      SUM(P.ActualWork) DESC 

As an aside, note that your table is literally named "IR.TimesheetHoursProjectTask" and not "TimesheetHoursProjectTask" under the "IR" schema. To specify the later, using the [] notation, it would be [IR].[TimesheetHoursProjectTask].

Answer 2

I think you need to remove the ActualWork field in Group By.