Interval Match (Extended)- Need Help *Urgent

[koushik_roy2]

Hi All,

I am having a issue when trying to write Interval Match.

I have two tables in my script.

Table 1:

START PERIOD	END PERIOD	EMP_ID
201101	201201	1023
201102	201202	1024
201103	201203	1025

And I have a table like below-

Table 2:

%Period
201101
201102
201103
201104
201105
Upto 201212

I need to create a new table like below-

Desired Table:-

%Period	START PERIOD	END PERIOD	EMP_ID
201101	201101	201201	1023
201101	201101	201202	1023
201101	201101	201203	1023
201101	201101	201204	1023
201101	201101	201205	1023
Upto the Last Period	....	....	....

Please help me out because its very urgent.

Regards,

Koushik.