--Once again, I'll build your test data firstDECLARE @TABLE AS TABLE([RequestID] INT,[RequestItemID] INT,[CostLocal] FLOAT,[Qty] INT,[Total_doller] FLOAT)INSERT INTO @TABLE([RequestID],[RequestItemID],[CostLocal],[Qty],[Total_doller])SELECT 331, 1036, 123.0000, 2, 5.05776UNION ALL SELECT 331, 1037, 100.0000, 3, 6.168--Now to the querySELECT [RequestID], SUM([Total_doller]) AS [Total]FROM @TABLEGROUP BY [RequestID]
/*RequestID Total----------- ----------------------331 11.22576*/