Is there a simple way to make this MTD instead of calculating the last month?
Select Count(PARENTACCOUNT) as Total_cars, SUM(Cast(ORIGINALBALANCE as decimal(10,2))) as Total_Amount
INTO #TEMP2
From car
Where type = '71'
and OPENDATE >= DATEADD(month, -1, convert(date, GETDATE()))
Need MTD instead of DATEADD(month, -1, convert(date, GETDATE()))