• 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.


    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.


  • Lokesh Vij


    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 -->[/url]

    Follow me @Twitter

  • Koen Verbeeck

    SSC Guru

    Points: 258965

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

    Need an answer? No, you need a question
    My blog at
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • demonfox


    Points: 6289

    nice question ...


    ~ 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)


    Points: 2705

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

  • TomThomson

    SSC Guru

    Points: 104773

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


  • 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.


  • Dana Medley


    Points: 6764

    Thanks for the great question.

    Everything is awesome!

  • WayneS

    SSC Guru

    Points: 95373

    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.

    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!
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • Raghavendra Mudugal


    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


    Points: 16565

    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