SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by bitbucket / APPLY - 2 / Latest Posts

RE: APPLY - 2

Hugo Kornelis — Fri, 05 Oct 2012 01:34:54 GMT

[quote][b]carl.landry (10/2/2012)[/b][hr]I just don't get what to do with this APPLY keyword.The query can be redone using a LEFT OUTER JOIN, which results in the same output and the same plan.Is APPLY easier to read for you? Are there cases where APPLY is the only way to go?[/quote][quote][b]carl.landry (10/2/2012)[/b][hr]Looks like I found an answer. The [url=http://technet.microsoft.com/en-us/library/ms175156(v=sql.105).aspx]documentation shows[/url] an example where APPLY is used to provide an argument to a table-function that require a parameter. It looks like it can't be done with a JOIN.[/quote]It's not just for calling user-defined table-valued functions. APPLY is also the only way to include a subquery that is correlated to another table in the same FROM clause. Your first post (that the query can be redone using LEFT OUTER JOIN) is not correct; when you do that, it will result in an error. (Okay, technically you are correct; with enough effort you can redo the query with LEFT OUTER JOIN, but that would require a non-trivial effort to rewrite the query, and the result would be harder to read and maintain).

RE: APPLY - 2

demonfox — Thu, 04 Oct 2012 01:29:56 GMT

thanks for the question

RE: APPLY - 2

SQLRNNR — Wed, 03 Oct 2012 12:14:16 GMT

Thanks for the question.

RE: APPLY - 2

carl.landry — Tue, 02 Oct 2012 08:18:44 GMT

Looks like I found an answer. The [url=http://technet.microsoft.com/en-us/library/ms175156(v=sql.105).aspx]documentation shows[/url] an example where APPLY is used to provide an argument to a table-function that require a parameter. It looks like it can't be done with a JOIN.

RE: APPLY - 2

carl.landry — Tue, 02 Oct 2012 08:16:01 GMT

I just don't get what to do with this APPLY keyword.The query can be redone using a LEFT OUTER JOIN, which results in the same output and the same plan.Is APPLY easier to read for you? Are there cases where APPLY is the only way to go?

RE: APPLY - 2

Jim_K — Mon, 01 Oct 2012 12:58:29 GMT

Coffee was a prerequisite in order for me to get this right.

RE: APPLY - 2

KWymore — Mon, 01 Oct 2012 11:27:35 GMT

Nice question! Glad I had my coffee first!

RE: APPLY - 2

Raghavendra Mudugal — Mon, 01 Oct 2012 10:10:02 GMT

Simply nice one. :-)

RE: APPLY - 2

WayneS — Mon, 01 Oct 2012 07:52:18 GMT

Good question Ron.If anyone wants to learn more about using the Apply operator, check out the "Using APPLY" links in my signature block for some great articles written by Paul White. He does an excellent job of walking you through it.

RE: APPLY - 2

Dana Medley — Mon, 01 Oct 2012 06:01:37 GMT

Thanks for the great question.

RE: APPLY - 2

tilew-948340 — Mon, 01 Oct 2012 05:46:45 GMT

Never heard of "Apply" before. Nice to know that "The difference between join and APPLY operator becomes evident when you have a table-valued expression on the right side and you want this table-valued expression to be evaluated for each row from the left table expression"Learn something again.Thanks!

RE: APPLY - 2

L' Eomot Inversé — Mon, 01 Oct 2012 05:28:13 GMT

Nice question.Glad I looked at it after breakfast, not before - without fuel I would probably have calculated 2+2+2+1+1+2 = 7 or something equally silly. Don'y you feel a bit cruel inflicting such advanced arithmetic on us on a Monday morning? :-D

RE: APPLY - 2

(Bob Brown) — Mon, 01 Oct 2012 05:21:37 GMT

Great question on a Monday morning. Gets me back on track after Fridays question.

RE: APPLY - 2

Jan Van der Eecken — Mon, 01 Oct 2012 04:41:49 GMT

Grrrr!!! Seems I can't count properly on a Monday morning.Good question though, Ron!

RE: APPLY - 2

Stewart "Arturius" Campbell — Mon, 01 Oct 2012 03:31:24 GMT

Good way to wake up the brain on a monday morning.Thanks, Ron

RE: APPLY - 2

DugyC — Mon, 01 Oct 2012 03:04:19 GMT

Good and interesting question for a Monday, thanks.

RE: APPLY - 2

demonfox — Mon, 01 Oct 2012 01:24:15 GMT

nice question ...thanks.

RE: APPLY - 2

Koen Verbeeck — Sun, 30 Sep 2012 23:17:37 GMT

Great question Ron. Almost missed that OUTER keyword on this Monday morning. :-)

RE: APPLY - 2

Lokesh Vij — Sun, 30 Sep 2012 22:28:56 GMT

Very nice question Ron. Thanks for posting :-)

RE: APPLY - 2

Mark Fitzgerald-331224 — Sun, 30 Sep 2012 00:39:48 GMT

Thanks for question. Easy one on a lazy morning.Fitz

APPLY - 2

bitbucket-25253 — Sun, 30 Sep 2012 00:37:33 GMT

Comments posted to this topic are about the item [B]APPLY - 2[/B]