tobbbe
9/22/2017 - 9:36 AM

Get rows current month

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