3bf0834b   
   From: david.martin@libero.it   
      
   On 07/07/2010 02:28 PM, crocboy25 wrote:   
   > Hello,   
   >   
   > I have a short procedure which compiles fine.  When the code is called   
   > from a webpage(.net) it runs the first time it is executed. However on   
   > the second time it throws an error saying "There is already an object   
   > named 'strPKHoldUp' in the database."  StrPKHold is a variable that I   
   > declare in the code as seen below....   
      
   'StrPKHold' is not a variable, it is a table that exists in the database.   
   If you put '@' before its name, it will be considered a variable:   
   select MR_MITIGATION_UPLOADS_MITIGATION_FK into @strPKHoldUp   
      
   --   
   David Martin   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)