Is there a way to access values return from a table-valued function? Sample code:
Need to call above function from stored procedure as follows;
Is this possible in SQL 2005?
Thanks in advance.
Above query works well if your function returns only one row, it will not be accurate if your function returns more than one row. In that case you should put your result to a temp table and process each rows using while loop as shown below.
answered Dec 13, 2012 at 05:27 PM