Thanks for your comments.

If am going with While loop option, client is rejecting because they need good performance query.

How can i set this query like set based solution please let me know.

How can i make this query to use a single insert into select from statement, Could you Please suggest me in detail.

thanks,

Antony