Post reply

Windowing Ranges

  • December 7, 2013 at 1:40 pm

    #72503

    Comments posted to this topic are about the item Windowing Ranges

  • December 8, 2013 at 5:15 pm

    #1671780

    Good question, took a bit of research to make sure I was correct, but got there in the end.

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • December 9, 2013 at 12:10 am

    #1671807

    nice question for basic knowledge related to windows functions Steve

    Thanks for sharing 🙂

  • December 9, 2013 at 12:26 am

    #1671811

    Easy one, thanks!

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

  • December 9, 2013 at 12:57 am

    #1671813

    Good one, Steve :), Thank you for the post.

    (forgive me for my poor English understanding capabilities... actually I had hard time in understanding the question itself; without taking BOL help or my existing knowledge on this matter, I picked wrong answers as I was not sure on what I was suppose to pick. I learnt new today, "English" wise.... 😎 )

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

  • December 9, 2013 at 1:12 am

    This was removed by the editor as SPAM

  • December 9, 2013 at 1:19 am

    #1671818

    Ford Fairlane (12/9/2013) [/B]

    Good question, took a bit of research to make sure I was correct, but got there in the end.

    + 1 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • December 9, 2013 at 1:32 am

    #1671821

    Nice QOTD Steve.

  • December 9, 2013 at 4:37 am

    #1671880

    Maybe worthwhile to mention that this functionality was introduced in SQL Server 2012.

  • December 9, 2013 at 6:31 am

    #1671913

    Thanks Steve

    +1

  • December 9, 2013 at 7:17 am

    #1671934

    Mighty (12/9/2013)

    Maybe worthwhile to mention that this functionality was introduced in SQL Server 2012.

    Yes! Had a heck of a time figuring it out, UNTIL I realized it must be something new for 2012. Then all became clear.

    Thanks for the question.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • December 9, 2013 at 10:02 am

    #1672039

    Straightforward and nice - thanks, Steve!

  • December 9, 2013 at 11:31 am

    #1672084

    Nice question Steve! I wish we would upgrade to 2012 around here so we could use these new functions.

    Good stuff.

    Ken

  • December 9, 2013 at 12:43 pm

    #1672103

    Any examples of how these would be used?

  • December 9, 2013 at 12:43 pm

    #1672104

    KWymore (12/9/2013)

    Nice question Steve! I wish we would upgrade to 2012 around here so we could use these new functions.

    Good stuff.

    Ken

    The upgrades to the OVER clause alone are, IMHO, worth the upgrade.

    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

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

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