Hi lyn,

I tested your solutions and it works. However they keep prompt me "the OVER SQL constructs or statements is not supported". I just ignored that. Do u have any idea whats that?

And ya i am sry, i did not asked for an SSIS solution and i do know this is an SQL job. However i am asked to see if i can do this in SSIS, which i am researching for it now. So asking for ur opinion.

Anyway thanks for replying.

Thanks,

10e5x

P.S I joined 3 forums to learn on SQL server and this forum is the best among all. Fastest reply rate with accuracy. THANKS!!!