My udf needs to be the first statement in the query and then there is a left join to a table. How can I rewrite this?
I know if table is first statement and udf is a second statement in the join, we can simply pass the col from first table to the udf
But I am confused on this one.
From dbo.udf_Myfunction(a.col1) udf
LEFT JOIN mytable a on udf.col = a.col1