SELECT options

  • Nice question. I have actually used with ties once in a reporting query. Glad to see a question about a rarely used piece of syntax.

  • Good question, learned something new. Thanks!

  • Nice Question. Got to learn something new today. Thanks. :-D:-)

  • Did not know about WITH Ties. Great question!

    Chris Umbaugh
    Data Warehouse / Business Intelligence Consultant
    twitter @ToledoSQL

  • Thanks for TIES

    IgorMi

    Igor Micev,
    My blog: www.igormicev.com

  • Good question, liked it. Never used WITH TIES but glad to know I remembered how it worked 🙂

    Some familiar names on the list!

  • Gazareth (4/18/2012)


    Good question, liked it. Never used WITH TIES but glad to know I remembered how it worked 🙂

    I'm glad you liked it too. I stumbled upon WITH TIES accidentally and thought it would be worth giving it a try.

    Some familiar names on the list!

    I was trying to build up some names, but found it easier to take some names from the community. Obviously, I had to be the "best seller" :-D.

    "El" Jerry.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • Great question, thanks! I didn't know about any "variations" of the top statement. Learned something new today.

  • very new question, learn something new .

    Thx 🙂

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • Good straightforward question. Thanks for submitting.

    http://brittcluff.blogspot.com/

  • Nice question. Learn something new...

    Thanks

  • Good question, thanks! It's always nice to brush up on things.

    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

  • WayneS (7/1/2012)


    Good question, thanks! It's always nice to brush up on things.

    Thank you, Wayne. Glad you liked it.

    "El" Jerry.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • Koen Verbeeck (4/12/2012)


    Very very nice question (not only because my name is in it :-D)

    Never used WITH TIES before, so I definately learned something.

    Good question to close the week.

    same here. And i hardly ever used % as well

    What you don't know won't hurt you but what you know will make you plan to know better
  • BudaCli (8/2/2012)


    Koen Verbeeck (4/12/2012)


    Very very nice question (not only because my name is in it :-D)

    Never used WITH TIES before, so I definately learned something.

    Good question to close the week.

    same here. And i hardly ever used % as well

    Thank you, BudaCli. Glad you liked it.

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

Viewing 15 posts - 46 through 60 (of 61 total)

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