Thread: Outer apply
01-07-14, 12:54 #1Registered User
- Join Date
- Jan 2014
Unanswered: Outer apply
I need to be able to pass the output of a function to another function as input, where all functions involved are user-defined in-line table-valued functions. I already posted this on Stack Exchange, where I was unable to find any assistance, so here is a link to the relevant code:
Correct way to pass table-valued function outputs to table-valued functions in SQL Server 2008 - Stack Overflow
I am fairly certain OUTER APPLY is the core answer here; there's *clearly* some way in which does *not* do what I need, or I would not get the null output you see in the link, but it seems clear that there should be a way to fool it into working. Does anyone know how to do this?
01-07-14, 14:28 #2Resident Curmudgeon
Provided Answers: 54
- Join Date
- Feb 2004
- In front of the computer
I haven't seen the code you posted, I can't visit Stack Exchange from here.
My first guess is that you need a CROSS APPLY instead of an OUTER APPLY.
-PatPIn theory, theory and practice are identical. In practice, theory and practice are unrelated.