Ajay Mavatkar

Ajay Mavatkar

  • NA
  • 68
  • 12.5k

iterate through table valued function in stored procedure

Mar 2 2017 7:46 AM
Hi,
 
I have written a sp which inserts certain data. Am calling table valued function inside that sp for one field(assume for date field) .Since table valued function is returning multiple values insert statement is terminating saying that the subquery returning more than one value.
 Can I get some suggestions asap for iterating the function values inside the sp itself..
 
Regards 

Answers (6)