troubleshooting Question

join a UDF on a join with its parameters?

Avatar of 25112
25112 asked on
Microsoft SQL Server 2005Microsoft SQL Server 2008SQL
1 Comment1 Solution324 ViewsLast Modified:
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?

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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros