View Single Post
  #14 (permalink)  
Old 05-13-2008, 12:45 AM
shaalini shaalini is offline
D-Web Analyst
 
Join Date: Apr 2007
Posts: 342
shaalini is on a distinguished road
Default 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.
Reply With Quote