The trick is to create a matrix of all possible values then see which clients do not cover all possibilities.

create table tbl_Cli_Insu (Client_Id int, eff_dt datetime, exp_dt datetime)

insert into tbl_Cli_Insu...