Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by David Poole A genuine use for a SQL CLR Aggregate RE: A genuine use for a SQL CLR Aggregate

  • January 3, 2011 at 9:12 am

    #1268521

    CELKO (12/29/2010)

    rdw-769613 (12/29/2010)

    Another good example to use CLR is GMT/Local/Unix time handling. Trying this in T-SQL is near imposible and within CLR it's simple and faster.

    I always did this by mimicking the ANSI/ISO Standards system tables for the WITH TIMEZONE option in the DDL. Then everything is done with VIEWs. No need for a CLR.

    Joe, do you have an article on this that you could link, or is this in one of your books? I've had my own issues with this over time 😀 and would like to see your implementation.

    Beer's Law: Absolutum obsoletum
    "if it works it's out-of-date"