• CELKO (12/15/2010)


    Please learn to follow ISO-11179 data element naming conventions and formatting rules. Temporal data should use ISO-8601 formats.

    Hey Joe - can you send these to us, or otherwise make them publicly available for free? Last time I checked, these things cost a pretty penny (nearly $1000 for the 11179), and my company isn't willing to spend that.

    IMO, if it's going to cost like that, it isn't really a standard, but a "I want to grow up and be a standard". It might be a good idea to follow standards, but we can't afford to.

    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