Results 1 to 8 of 8

Thread: POISSON in TSQL

  1. #1

    Thread Starter
    Frenzied Member FishGuy's Avatar
    Join Date
    Mar 2005
    Location
    Bradford UK
    Posts
    1,708

    POISSON in TSQL

    Im looking for a POISSON function in SQL Server like the one in excel to calculate football probability, does the function exist as I find no documentation and if not any ideas how i could create one?

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: POISSON in TSQL

    Look under the Statistical functions for XLeratorDB

  3. #3

    Thread Starter
    Frenzied Member FishGuy's Avatar
    Join Date
    Mar 2005
    Location
    Bradford UK
    Posts
    1,708

    Re: POISSON in TSQL

    That costs 500 pound I was hoping there would be a free function built in.

    It shows the formula, but those math symbols mean nothing to me, do you suppose it would be dificult to work out how to create the function myself?

    http://westclintech.com/Products/XLe...N/Default.aspx

  4. #4
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: POISSON in TSQL

    How good are you in C#?

    I found this example, but it is in C#....

  5. #5
    Hyperactive Member
    Join Date
    May 2006
    Posts
    365

    Re: POISSON in TSQL

    Add a reference to EXCEL in you application and you will automatically have access to the Piosson function, in fact any and all functions contained in EXCEL.

    Kind regards

    Steve

  6. #6

    Thread Starter
    Frenzied Member FishGuy's Avatar
    Join Date
    Mar 2005
    Location
    Bradford UK
    Posts
    1,708

    Re: POISSON in TSQL

    Will that work for a asp.net web app even if I dont have excel on the server?
    If it will that would be fine?

  7. #7
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,297

    Re: POISSON in TSQL

    Quote Originally Posted by FishGuy View Post
    Will that work for a asp.net web app even if I dont have excel on the server?
    If it will that would be fine?
    No it won't.

  8. #8

    Thread Starter
    Frenzied Member FishGuy's Avatar
    Join Date
    Mar 2005
    Location
    Bradford UK
    Posts
    1,708

    Re: POISSON in TSQL

    Oh then it looks like I will have to examine the c# examples a little more, I was hoping to just pass three parameters to a function but oh well.

    The classes in the examples dont make much sense to me using lamda at the moment.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width