SELECT [dte] ,Year([dte]) as RP_Year ,[LOB] ,Sum([Cost]) as Sum_cost FROM xxx Where [RP_Year] = '2017' Group by [LOB]
SELECT [dte] ,Year([dte]) as RP_Year ,[LOB] ,Sum([Cost]) as Sum_cost FROM xxx Where Year([dte]) = '2017' Group by [LOB]
WHERE [dte] >= CAST('20170101' As date) And [dte] < CAST('20180101' As date)
cost
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)