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
– Eric, Commented Jan 5, 2012 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
– Sami, Commented Jan 5, 2012 at 20:31
possible duplicate of "Incorrect syntax" using a table-valued function in SELECT clause of T-SQL query — gbn
– gbn, Commented Jan 5, 2012 at 22:02

gbn · Accepted Answer · 2012-01-05 22:00:35Z

6

answered Jan 5, 2012 at 22:00

gbn

434k84 gold badges602 silver badges690 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

JNK · Accepted Answer · 2012-01-05 20:31:27Z

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 5, 2012 at 20:31

JNK

65.5k15 gold badges127 silver badges138 bronze badges

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

Abdul Rasheed · Accepted Answer · 2017-03-30 07:46:08Z

0

Maybe try being a bit more explicit -

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

Abdul Rasheed

6,7794 gold badges36 silver badges50 bronze badges

answered Jan 5, 2012 at 20:34

DigitalJedi805

1,4604 gold badges17 silver badges42 bronze badges