Join To Multi-statement table-valued function 1

[PWise]

If I have A Multi-statement table-valued function can I somehow join it to a regulear table

Select * 
from Tablename
inner join dbo.functionname(Pramname)
on ????=????

or perhaps pass a fieldname as a prameter

Select Tablename.*, dbo.functionname(Tablename.Fieldname)
from Tablename

 

[gmmastros]

For SQL2000, I think the answer is NO. If you are using SQL2005 (or higher), take a look at the Cross Apply statement.

http://www.sqlteam.com/article/using-cross-apply-in-sql-server-2005

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[PWise]

gmmastros:
Thanks for the info I am using SQL Server 2000

Have A Star!

 

[gmmastros]

I think I would be tempted to create a table variable and dump the data from the table-valued function in to the table variable, where you can then link to it.

Of course, to change the parameter each time means you're doing this in a loop.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom