I have a function created to calculate pricing on parts
I'm trying to run the function as a cross apply to my item file and using each item as a parameter in my function when it is called.
I'm receiving an error when i attempt to run the select statement.
Msg 102, Level 15, State 1, Line 6
Incorrect syntax near '.'.
What am I doing wrong with my syntax?
from gp9prd.cmp.dbo.iv00101 iv1 (nolock)
cross apply dbo.ufnGetACCTPricing(iv1.itemnmbr, '') pl
where iv1.itemtype <>'2'
Please not that the connection to the part master list is using a linked server