Re: Sql loop Statement hi bluesky,
I have followed the same procedure as u have mentioned. Its working fine. If i execute the code more than once i got the error as There is already an object named '#Clones' in the database.So i have changed the '#Clones' in to different name when each and every time it executes.
__________________ Shaalini.S Be the Best of Whatever you are...
Last edited by shaalini : 05-13-2008 at 12:54 AM.
|