function returning table

[liuk]

Hi
How is it possible to join a function returnin a table with a table?

If i write :

Select Document.IdDoc, F.Id
From Document inner join dbo.FNC_GetData(Document.IdDoc) F on Document.IdDoc = F.IdDoc

i get an error "Incorrect syntax near '.'"

If i write
Select Document.IdDoc, F.Id
From Document inner join dbo.FNC_GetData(IdDoc) F on Document.IdDoc = F.IdDoc

i get an error
'IdDoc' is not a recognized OPTIMIZER LOCK HINTS option.

Someone could help me?
thanks

 

[AlexCuse]

Why not have your proc dump results in a temp table, join to this, then after you are done querying it drop the table?

HTH,

Alex

It's a magical time of year in Philadelphia. Eagles training camp marks the end of another brutal season of complaining about the Phillies.

 

[liuk]

The function parameter is a field of the other joining table.
Someone could tell me why it doesn't works?

 

[SQLDenis]

Table-valued functions are called by using a one-part name:

Select d.IdDoc, F.Id
From Document d inner join FNC_GetData(Document.IdDoc) F on d.IdDoc = F.IdDoc

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/