From: me@myplace.net   
      
   Tony C. schreef op 02-10-2011 20:32:   
   > Thanks Again...   
      
   If I need to assign data from a table to a variable, I use SELECT   
   @VariableX = ColumnX FROM TableX WHERE ConditionX   
      
   If I need to assign data to a variable where the data does not come from   
   a table (literal value, some calculation), I use SET @VariableX =   
   'literal value' / 2 * 146 / GETDATE()   
      
   Just one of my coding standards that help improve overall code quality   
   and probably a standard that can be argued about, but it's my standard.   
      
   Just my 2 cents.   
      
   Best,   
   Henk   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)