Post reply

APPLY - 2

  • September 30, 2012 at 12:37 am

    #263070

    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]

  • September 30, 2012 at 12:39 am

    #1543724

    Thanks for question. Easy one on a lazy morning.

    Fitz

  • September 30, 2012 at 10:28 pm

    #1543778

    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

  • September 30, 2012 at 11:17 pm

    #1543780

    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

  • October 1, 2012 at 1:24 am

    #1543796

    nice question ...

    thanks.

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

  • October 1, 2012 at 3:04 am

    #1543845

    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]

  • October 1, 2012 at 3:31 am

    This was removed by the editor as SPAM

  • October 1, 2012 at 4:41 am

    #1543910

    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]

  • October 1, 2012 at 5:21 am

    #1543921

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

  • October 1, 2012 at 5:28 am

    #1543925

    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

  • October 1, 2012 at 5:46 am

    #1543929

    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!

  • October 1, 2012 at 6:01 am

    #1543933

    Thanks for the great question.


    Everything is awesome!

  • October 1, 2012 at 7:52 am

    #1543983

    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

  • October 1, 2012 at 10:10 am

    #1544047

    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.

  • October 1, 2012 at 11:27 am

    #1544070

    Nice question! Glad I had my coffee first!

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

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