HI All,
Please can one explain below logic:
select @EndDate = DATEADD(DD,1,MonthEndDate)
FROM MonthDim WHERE MonthDimKey = convert(int, convert(varchar(6), (DATEADD (MM , -1 , GETDATE())), 112))
SELECT @startdate = MonthStartDate
FROM MonthDim WHERE MonthDimKey = convert(int, convert(varchar(6), (DATEADD (MM , -1 , GETDATE())), 112))
Thanks