jon-688305, thank you very much for you input. I am sorry if I did not stressed enough that the data

in the tables is not correct/valid for multiple rows and I ignored the fact that for these rows

Quater/ReportMonth relationship is invalid. The provided solution does produce valid result set

based on Year/Month/Day.

I do use CROSS APPLY and Outer Apply operators a lot.

Thanks

Regards