July 25, 2013 at 10:29 am
Hi I'm newbie to SQL ...
Please explain in simpler words. What is Cross Apply ?
Examples pls...
July 25, 2013 at 1:47 pm
Simply put: you join a table with a table valued function.
This article explains the concept and has some examples:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 25, 2013 at 7:45 pm
Here are some additional links:
Understanding and Using APPLY (Part 1)[/url] by Paul White
Understanding and Using APPLY (Part 2)[/url] by Paul White
The Cascading (CROSS) APPLY[/url] by Chris Morris
And don't miss the first link in my signature for a neat way to UNPIVOT using CROSS APPLY.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
July 25, 2013 at 7:52 pm
You can also check out this series of blog posts
http://mattvelic.com/tsql-tuesday-17-roundup/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply