From: rpresser@gmail.com   
      
   On Wednesday, March 12, 2014 11:41:41 PM UTC-4, migurus wrote:   
   > My difficulty is that SP can return output parameters, but it seems I can't   
   call SP in select? The UDF can be called from select but can not return more   
   than one value and I need to return at least two, in fact 4 values, I just   
   simplified everything.   
      
   UDFs can return TABLE variables, which would let you return more than one   
   value, but that doesn't really help -- you still can't run it on a table input   
   and get a table output.  Your best bet is to have RUN() be a stored procedure   
   that operates on an    
   entire table of input and returns a resultset with output for all rows.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)