Home Forums Article Discussions Article Discussions by Author Discuss content posted by Paul White A round number RE: A round number

  • May 5, 2010 at 8:00 am

    #1162453

    Paul White NZ (5/4/2010)

    Thanks Wayne, that's very useful! My only remaining question is what versions of SQL Server (engine and SSMS) you are running. I guess they are similar to mine - and you have patched your SSMS as well as the server - since our results agree so well.

    isql eh? :blink:

    Servers:

    SQL 2008: 10.0.1600.22

    SQL 2005: 9.00.4053.00

    SQL 2000: 8.00.2055

    SSMS 2008: 10.0.1600.22

    SSMS 2005: 9.00.4035.00

    SQL Query Analyzer 8.00.2039

    I'll edit this to include SSMS 2005 later... have to get that from a co-worker.

    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