How to get all dates between two date without Friday or a specific day in SQL:

Get All Date between two date without Friday or a specific day : 

DECLARE @MinDate DATE = '20190301',

        @MaxDate DATE = '20190320';

Select *  from (

SELECT  TOP (DATEDIFF(DAY, @MinDate, @MaxDate) + 1) Date = DATEADD(DAY, ROW_NUMBER() OVER(ORDER BY a.object_id) - 1, @MinDate),DATENAME(dw,DATEADD(DAY, ROW_NUMBER() OVER(ORDER BY a.object_id) - 1, @MinDate))dName

FROM    sys.all_objects a

CROSS JOIN sys.all_objects b) b  where b.dName <> 'friday'