From: esquel@sommarskog.se   
      
   migurus (migurus@yahoo.com) writes:   
   > 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.   
      
   You can make it a table-valued function that returns a one row result   
   set, and then use cross apply:   
      
   SELECT ..   
   FROM   tbl   
   CROSS APPLY dbo.run(col1, col2) AS run   
      
   However, as Ross says, it is better if you can implement something that   
   operates on a set of data, taking the input from a table-valued parameter.   
   For large data sets, this could be a dramatic difference in performance.   
      
   --   
   Erland Sommarskog, Stockholm, esquel@sommarskog.se   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)