Question: Here is the sample
![See Sample](https://i.stack.imgur.com/VUGo3.png)

How to get this data based on day name from my table?

Answer: 
You should really fix your design. Each doctor/day tuple should be stored as a separate *row* rather than in columns.

For your current data structure, I would recommend unpivoting, then filtering:

```
select t.doctorname, v.*
from mytable t
cross apply (values 
    ('Sunday', sunday)
    ('Monday', monday)
    ...
) v(dy, val)
where v.dy = datename(weekday, getdate())

```
The following query will help you to get result:

```
DECLARE @SqlQuery varchar(8000) 
DECLARE @DateVal DATE = GETDATE(), @DayName varchar(20)
SET @DayName = DATENAME(WEEKDAY, @DateVal);
SET @SqlQuery ='SELECT DOCTORNAME FROM TABLE_NAME WHERE '+ @DayName +'= 1'
EXEC(@SqlQuery)

```