Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 possible to call a udf with a table variable as parameter?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-02-01 : 07:42:29
Iain writes "Hi

writing an app in SQl 2000, and have a udf which will call some subroutines - also written as udfs. I want the main udf routine to collate a single results-set, which is built incrementally by the udf-subroutines. So I thought it would be trivial to pass each sub-routine the current results-set as a table variable, let each do their stuff, then return results-so-far to the calling udf. Seem to get compile errors though when I try, so is it possible to do this?"
   

- Advertisement -