Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1728

Re: help with output parameters needed

Show all headers | View raw

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.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

help with output parameters needed migurus <migurus@yahoo.com> - 2014-03-12 20:41 -0700
  Re: help with output parameters needed Ross Presser <rpresser@gmail.com> - 2014-03-12 21:01 -0700
  Re: help with output parameters needed Erland Sommarskog <esquel@sommarskog.se> - 2014-03-13 08:40 +0100

csiph-web