SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

with t as (
    select '12/21/2006' as TheDay, 1 as TheValue union all
    select '12/22/2006' as TheDay, 1 as TheValue union all
    select '12/23/2006' as TheDay, 1 as TheValue union all
    select '12/24/2006' as TheDay, 1 as TheValue union all
    select '12/25/2006' as TheDay, 0 as TheValue union all
    select '12/26/2006' as TheDay, 1 as TheValue union all
    select '12/27/2006' as TheDay, 0 as TheValue union all
    select '12/28/2006' as TheDay, 0 as TheValue union all
    select '12/29/2006' as TheDay, 1 as TheValue union all
    select '12/30/2006' as TheDay, 1 as TheValue union all
    select '12/31/2006' as TheDay, 0 as TheValue union all
    select '01/01/2007' as TheDay, 0 as TheValue union all
    select '01/02/2007' as TheDay, 0 as TheValue union all
    select '01/03/2007' as TheDay, 0 as TheValue union all
    select '01/04/2007' as TheDay, 0 as TheValue union all
    select '01/05/2007' as TheDay, 0 as TheValue union all
    select '01/06/2007' as TheDay, 0 as TheValue union all
    select '01/07/2007' as TheDay, 1 as TheValue union all
    select '01/08/2007' as TheDay, 1 as TheValue
)
select cast(theday as date) as day, thevalue as value
into t
from t

19 rows affected

day	value	newvalue
25/12/2006 00:00:00	0	1
27/12/2006 00:00:00	0	1
28/12/2006 00:00:00	0	1
31/12/2006 00:00:00	0	0
01/01/2007 00:00:00	0	0
02/01/2007 00:00:00	0	0
03/01/2007 00:00:00	0	0
04/01/2007 00:00:00	0	0
05/01/2007 00:00:00	0	0
06/01/2007 00:00:00	0	0
21/12/2006 00:00:00	1	1
22/12/2006 00:00:00	1	1
23/12/2006 00:00:00	1	1
24/12/2006 00:00:00	1	1
26/12/2006 00:00:00	1	1
29/12/2006 00:00:00	1	1
30/12/2006 00:00:00	1	1
07/01/2007 00:00:00	1	1
08/01/2007 00:00:00	1	1