• But I want to use a recursive CTE here.. rather than In clause. This is because, grouping will be per date field.