Results 1 to 2 of 2

Thread: Outer apply

  1. #1
    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?

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    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.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts