Inline Table UDF does not accept table data

Hello All,

I have a simple TestFunction UDF

Code:

---

CREATE FUNCTION dbo.TestFunction ( @Idx int )
RETURNS @TestTabel TABLE  ( Idx int, Field1 int, Field2 int )
AS
BEGIN
        INSERT @TestTabel ( Idx, Field1, Field2 )
        SELECT @Idx, 1, 2
        RETURN
END

---

Inserted in a query

Code:

---

SELECT TestFunction.Idx, TestFunction.Field1, TestFunction.Field2
FROM dbo.TestFunction(dbo.TempItems.ID) TestFunction INNER JOIN
    dbo.TempItems ON TestFunction.Idx = dbo.TempItems.ID

---

When I want to execute it Ill get the following message

Quote:

---

Error in list of function arguments: '.' not recognized.
Incomplete parameters list.

---

So dbo.TempItems.ID is not axepted as an value but is interpreted as text

If I execute the query with a fixed value then it runs fine.

Code:

---

SELECT  TestFunction.Idx, TestFunction.Field1, TestFunction.Field2
FROM dbo.TestFunction(12) TestFunction INNER JOIN
    dbo.TempItems ON TestFunction.Idx = dbo.TempItems.ID

---

How do I get a table of numbers in it?

Regards,

Marco