Post reply

Excel RATE function replication SQL Server

  • November 25, 2011 at 3:45 am

    #252554

    Hi,

    Is there a ready to use code available for replicating RATE function for Excel in SQL Server? I have seen a couple of codes but they are a little off.

    Please share a code if available

  • November 25, 2011 at 10:23 am

    #1413038

    A google search provided quite a few links claiming to provide an Excel-like functionality.

    Some of the solutions are CLR based and should return the correct result. ("correct" in terms of mathematically correct, not in terms of "identical to Excel"... ;-))


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • February 5, 2012 at 2:26 pm

    #1442854

    I created a CLR solution that I believe to identical to Excel

Viewing 3 posts - 1 through 3 (of 3 total)

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