grp |
(case when fact_date is null then seqnum end) |
(case when fact_date is not null then datediff(date_dt, fact_date) end) |
date_dt |
fact_date |
seqnum |
seqnum_2 |
Missing |
0 |
null |
2018-01-01 |
null |
0 |
1 |
Missing |
0 |
null |
2018-01-02 |
null |
0 |
2 |
Missing |
0 |
null |
2018-01-03 |
null |
0 |
3 |
Present |
null |
0 |
2018-01-04 |
2018-01-04 |
1 |
3 |
Present |
null |
0 |
2018-01-05 |
2018-01-05 |
2 |
3 |
Missing |
2 |
null |
2018-01-06 |
null |
2 |
4 |
Missing |
2 |
null |
2018-01-07 |
null |
2 |
5 |
Missing |
2 |
null |
2018-01-08 |
null |
2 |
6 |
Missing |
2 |
null |
2018-01-09 |
null |
2 |
7 |
Missing |
2 |
null |
2018-01-10 |
null |
2 |
8 |
Missing |
2 |
null |
2018-01-11 |
null |
2 |
9 |
Missing |
2 |
null |
2018-01-12 |
null |
2 |
10 |
Missing |
2 |
null |
2018-01-13 |
null |
2 |
11 |
Missing |
2 |
null |
2018-01-14 |
null |
2 |
12 |
Missing |
2 |
null |
2018-01-15 |
null |
2 |
13 |
Missing |
2 |
null |
2018-01-16 |
null |
2 |
14 |
Missing |
2 |
null |
2018-01-17 |
null |
2 |
15 |
Missing |
2 |
null |
2018-01-18 |
null |
2 |
16 |
Missing |
2 |
null |
2018-01-19 |
null |
2 |
17 |
Missing |
2 |
null |
2018-01-20 |
null |
2 |
18 |
Missing |
2 |
null |
2018-01-21 |
null |
2 |
19 |
Present |
null |
0 |
2018-01-22 |
2018-01-22 |
3 |
19 |
Missing |
3 |
null |
2018-01-23 |
null |
3 |
20 |
Missing |
3 |
null |
2018-01-24 |
null |
3 |
21 |
Missing |
3 |
null |
2018-01-25 |
null |
3 |
22 |
Missing |
3 |
null |
2018-01-26 |
null |
3 |
23 |
Missing |
3 |
null |
2018-01-27 |
null |
3 |
24 |
Missing |
3 |
null |
2018-01-28 |
null |
3 |
25 |
Missing |
3 |
null |
2018-01-29 |
null |
3 |
26 |