Hey Guys,
I'm having trouble getting my head around these two, CROSS APPLY / OUTER APPLY.
I don't have a specific example that I need help with, I'm just studying towards an exam (MCTS 70-433). The book has about a paragraph about them, so I'm guessing they won't feature to heavily in the exam... but I'd still like to know how to use them.
Firstly, I don't really see the point of them. I've read a few articles about them in trying to understand them, and they have all said that performace wise, JOIN's are a better way to go.
My understanding of how they work is that you write a SELECT from a permanent table and temporary table created by the function specifying the columns. Then CROSS / OUTER APPLY your function, passing in which ever value is required for the function to be successful.
Could someone confirm that my understand is correct, or if it isn't correct please tell me what I'm missing!
I'm having trouble getting my head around these two, CROSS APPLY / OUTER APPLY.
I don't have a specific example that I need help with, I'm just studying towards an exam (MCTS 70-433). The book has about a paragraph about them, so I'm guessing they won't feature to heavily in the exam... but I'd still like to know how to use them.
Firstly, I don't really see the point of them. I've read a few articles about them in trying to understand them, and they have all said that performace wise, JOIN's are a better way to go.
My understanding of how they work is that you write a SELECT from a permanent table and temporary table created by the function specifying the columns. Then CROSS / OUTER APPLY your function, passing in which ever value is required for the function to be successful.
Could someone confirm that my understand is correct, or if it isn't correct please tell me what I'm missing!