Get Day and Day Name with Holidays in SQL Server

I already given the input Details please refer the below link.

http://www.aspforums.net/Threads/123184/How-to-get-Day-and-Day-Name-with-assigning-Sunday-as-Holiday-in-SQL-Server/

I have one more table Holiday name.this table store the holiday Date and Holiday Name.

I want  Output like this.

Date          DayName    EmployeeName

30-10-2016   Sunday            Holiday

31-10-2016    Moday             Diwali

Please help me