Hi Lynn,
Yup i tried, it doesn't. Thanks for all the help over here, i have successfully created all the statements needed for my requirement and my target table is derived. Now i shall move on to see if it is possible to do in the SSIS way, which will be out of topic for this forum.
Thanks.
Appreciated,
10e5x