SQL Function for generating dates CREATE FUNCTION dbo.GeneratingDates ( @DateStart DATE, -- Start Date @DateEnd DATE -- End date ) RETURNS @ListDates TABLE (dt DATE,WDay TINYINT,WDaysName NVARCHAR(20) ...