The conditional where clause works fine for small sets of data but it is not very efficient. For large data sets it is better to stick to the dynamic...

This produces the result requested:

select

da.ID,

         da.Date,

         sw.HRS_WKLY,

         sw