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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.