Thanks For your reply . I tried the settings in the above link but it did not workout

Below is the another solution to achieve this and it...

I have executed the above script . But some tables are missing .

Hi Thanks of the reply

i am trying to implement the CTE which is posted above . Thank you so much . And keep you update on this .

that is one table . As we have space constraint while post the question

i kept in two parts