View Single Post
  #15 (permalink)  
Old 05-13-2008, 12:48 AM
bluesky bluesky is offline
D-Web Analyst
 
Join Date: Jun 2007
Posts: 201
bluesky is on a distinguished road
Default Re: Sql loop Statement

Hi shaalini,
Not quite the way to do it... if you convert the code to a stored procedure and run it, #Clone will drop itself at the completion of the stored procedure, automatically. You're trying to run it more than once as a simple script and you need to forcibly drop #Clone for additional runs
Reply With Quote