Nevyn,

At the outset, thanks a bunch !

Yes, it was a typo btw and I didnt mean to give you more trouble than I already have.

Let me test it out &...

More or less, you can take the answer as 4.

What I need to tell you also is this that when ever this query runs, it is expected to update the...

Nevyn,

Lapse is a column that is acting as a flag here & it need to be updated to 1 whenever the under the following conditions

- Update this flag...

Sure !

Thanks again for follow up.

Yes, you are right in that all the data is still there & we just need to update the CoverageTimePeriod Column. Im looking for the...

Nevyn,

I cant commend enough on your eagerness to help here.

Yes, it is a bit odd enough for me & when I tried to explain to my other fellow workers, they...