APPLY - 2

  • Ron McCullough

    SSC Guru

    Points: 63877

    Comments posted to this topic are about the item APPLY - 2

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Mark Fitzgerald-331224

    SSCrazy Eights

    Points: 8489

    Thanks for question. Easy one on a lazy morning.

    Fitz

  • Lokesh Vij

    SSChampion

    Points: 10836

    Very nice question Ron. Thanks for posting 🙂

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Koen Verbeeck

    SSC Guru

    Points: 258955

    Great question Ron. Almost missed that OUTER keyword on this Monday morning. 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • demonfox

    SSCertifiable

    Points: 6289

    nice question ...

    thanks.

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

  • DugyC

    Hall of Fame

    Points: 3804

    Good and interesting question for a Monday, thanks.

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • This was removed by the editor as SPAM

  • Jan Van der Eecken

    SSCrazy Eights

    Points: 8890

    Grrrr!!! Seems I can't count properly on a Monday morning.

    Good question though, Ron!

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

  • (Bob Brown)

    SSCrazy

    Points: 2705

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

  • TomThomson

    SSC Guru

    Points: 104772

    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? 😀

    Tom

  • tilew-948340

    Hall of Fame

    Points: 3431

    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!

  • Dana Medley

    SSCertifiable

    Points: 6764

    Thanks for the great question.



    Everything is awesome!

  • WayneS

    SSC Guru

    Points: 95342

    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
    Author - SQL Server T-SQL Recipes


    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
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Simply nice one. 🙂

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Ken Wymore

    SSCoach

    Points: 16429

    Nice question! Glad I had my coffee first!

Viewing 15 posts - 1 through 15 (of 21 total)

You must be logged in to reply to this topic. Login to reply