DECLARE @begindate date = getdate()

DECLARE @enddate date = getdate()

SELECT DATENAME(weekday, Orders.DateCreated) as [Weekday], Orders.DateCreated as [Date], Categories.CategoryName as Category, Authors.State, isnull(SUM(OrderDetails.OrderID),0) as [NumberSold]

INTO #booksales

FROM Books

Left Outer join OrderDetails on Books.BookID...