declare @date smalldatetime set @date = dateadd(dd, -1, convert(varchar(10), getdate(), 101)) insert into DayStoreCat_Committed (RetailDate, StoreNo, Category, Committed_Units, Committed_Retail) select @date, StoreNo, Category, sum(Committed_Units), sum(Committed_Retail) from ItemStCt group by StoreNo, CategoryShould I add the @date to the group by or is it correct the way I have it.