Pass Parameters to Table Function

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

General SQL Server Forums

New to SQL Server Programming

Pass Parameters to Table Function

Author

Topic

petersrj
Starting Member

20 Posts

Posted - 2011-06-06 : 11:39:12

I have written a custom function which takes in 5 parameters and returns a table after manipulating those input parameters. The function works correctly when run as follows:

Select * from dbo.MyNewFunc(1, 2, 3, 4, 5)

What I would like to do is to have the five parameters come from a select statement. Something like:

Select * from dbo.MyNewFunc(
(Select Data1, Data2, Data3, Data4, Data5 from AnotherTable)
)

When I try this I get than an insufficient number of arguements were supplied for the function. Is this possible?

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2011-06-06 : 12:19:13

What version of SQL Server are you in?

Might work:

Select A.Data1, A.Data2, A.Data3, A.Data4, A.Data5, B.*
From AnotherTable A
Cross Apply dbo.MyNewFunc(Data1, Data2, Data3, Data4, Data5) B

Corey