Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Join To Multi-statement table-valued function 1

Status
Not open for further replies.

PWise

Programmer
Dec 12, 2002
2,633
US
If I have A Multi-statement table-valued function can I somehow join it to a regulear table
Code:
Select * 
from Tablename
inner join dbo.functionname(Pramname)
on ????=????

or perhaps pass a fieldname as a prameter
Code:
Select Tablename.*, dbo.functionname(Tablename.Fieldname)
from Tablename
 
gmmastros:
Thanks for the info I am using SQL Server 2000

Have A Star!
 
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. [sad]



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top