This query gives me 10,185
select SUM(int_BenefitEquation) AS total_hours from net_BudgetTools..tbl_DEVELOPERS_Projects where dte_DateOnProduction<='2015-04-07'
This query gives me 9,075
SELECT SUM(ISNULL(int_BenefitEquation, 0)) AS BenefitHours FROM net_BudgetTools..tbl_DEVELOPERS_Projects
DATEPART(year, dte_DateOnProduction) = '2015'
What's the difference? Basically, I want all of the projects that went into production this year. What's the difference between these two queries that I would wind up with two different figures?