APPLY - 2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by bitbucket » APPLY - 2

21 posts, Page 2 of 3

««1 2 3 »»

APPLY - 2

Rate Topic

Display Mode

Topic Options

Author

Message

tilew-948340

Posted Monday, October 01, 2012 5:46 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 8:28 PM
Points: 555, Visits: 2,137

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!

Post #1366502

Dana Medley

Posted Monday, October 01, 2012 6:01 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:52 PM
Points: 1,350, Visits: 870

Thanks for the great question.

Oh no, we're toast! I've got this. *Keyboard clatter* Woah, how'd you do that? I'm a DBA...Booyah

Yeah, uh huh, you know what it is. Everything I do, I do it big

Post #1366506

WayneS

Posted Monday, October 01, 2012 7:52 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 5:29 PM
Points: 6,367, Visits: 8,226

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.

Wayne
Microsoft Certified Master: SQL Server 2008

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings

Post #1366574

Raghavendra Mudugal

Posted Monday, October 01, 2012 10:10 AM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 9:56 AM
Points: 443, Visits: 1,191

Simply nice one. Smile

ww; Raghu
--
There are only 10 types of people in the world, those who understand binary, and those who don't.

Note: (as of now) only.. 1 and 4 applies (i am on my way...)

Post #1366647

KWymore

Posted Monday, October 01, 2012 11:27 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:58 AM
Points: 2,570, Visits: 1,530

Nice question! Glad I had my coffee first!

Post #1366678

Jim_K

Posted Monday, October 01, 2012 12:58 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:51 PM
Points: 59, Visits: 638

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

Post #1366710

carl.landry

Posted Tuesday, October 02, 2012 8:16 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, April 12, 2013 9:39 AM
Points: 1,211, Visits: 148

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?

Post #1367065

carl.landry

Posted Tuesday, October 02, 2012 8:18 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, April 12, 2013 9:39 AM
Points: 1,211, Visits: 148

Looks like I found an answer. The documentation shows 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.

Post #1367069

SQLRNNR

Posted Wednesday, October 03, 2012 12:14 PM

SSCoach

Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:46 PM
Points: 18,732, Visits: 12,329

Thanks for the question.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1367933

demonfox

Posted Thursday, October 04, 2012 1:29 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:46 PM
Points: 1,074, Visits: 1,076

thanks for the question

~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one Ermm

Post #1368198

« Prev Topic | Next Topic »

21 posts, Page 2 of 3

««1 2 3 »»

Permissions