Link to home
Create AccountLog 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
Create an account to see this answer
Signing up is free. No credit card required.
Create Account