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