Incorrect syntax near '.' in sql server table values function

Question

I am trying to join with table values function, it gives me error this error:

Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near '.'.

SELECT * from tbl t
inner join dbo.ufn_CSVToTable(t.text) a 
on t.text = a.String

What can be the error?

Please post the code behind the function--can't help you otherwise. — Eric, Jan 05 '12 at 20:28
function is fine i have checked this. if i execute the function like this SELECT * from dbo.ufn_CSVToTable('1,2,3') then it works fine but when i pass the column name as parameter then it gives error. — Sami, Jan 05 '12 at 20:31
as i have mentioned that ufn_CSVToTable is table values function. — Sami, Jan 05 '12 at 20:34
possible duplicate of ["Incorrect syntax" using a table-valued function in SELECT clause of T-SQL query](http://stackoverflow.com/questions/5103624/incorrect-syntax-using-a-table-valued-function-in-select-clause-of-t-sql-query) — gbn, Jan 05 '12 at 22:02

score 6 · Answer 1 · answered Jan 05 '12 at 22:00

6

answered Jan 05 '12 at 22:00

gbn

score 3 · Answer 2 · answered Jan 05 '12 at 20:31

3

Try using CROSS APPLY instead of JOIN:

SELECT * from tbl t
CROSS APPLY dbo.ufn_CSVToTable(t.text) a 
WHERE t.text = a.String

answered Jan 05 '12 at 20:31

JNK

error: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near 'APPLY'. – Sami Jan 05 '12 at 20:37
2

Need to be compat level 90 or higher too http://msdn.microsoft.com/en-us/library/bb510680.aspx – gbn Jan 05 '12 at 22:01

score 0 · Answer 3 · edited Mar 30 '17 at 07:46

0

Maybe try being a bit more explicit -

SELECT * from tbl
inner join dbo.ufn_CSVToTable(tbl.text) a 
on tbl.text = a.String

edited Mar 30 '17 at 07:46

Abdul Rasheed

answered Jan 05 '12 at 20:34

DigitalJedi805

3 Answers3