Link to home
Start Free TrialLog in
Avatar of 25112
25112

asked on

join a UDF on a join with its parameters?

feasability of joining UDF parameters in a (cross) join?

what is missing in being able to join the parameters of the below udf with a derived table?

thanks-
------------------
SELECT t.* FROM dbo.func_UDF (@UDTT, U.column1, U.column2, U.column3) AS t CROSS APPLY
(SELECT column1, column2, column3 FROM join and conditions) AS U

@UDTT is a user defined user table type with READONLY attribute.
ASKER CERTIFIED SOLUTION
Avatar of ralmada
ralmada
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial