declare @yyear int declare @mmonth int set @mmonth = DATEPART(mm, SYSDATETIME()) set @yyear = DATEPART(yyyy, SYSDATETIME()) select SUM(businessvalue) from business where DATEPART(mm, quotesent) = @mmonth and DATEPART(yyyy, quotesent) = @yyear