-
Dec 28th, 2011, 08:10 AM
#1
Thread Starter
Frenzied Member
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?
-
Dec 28th, 2011, 08:25 AM
#2
Re: POISSON in TSQL
Look under the Statistical functions for XLeratorDB
-
Dec 28th, 2011, 08:38 AM
#3
Thread Starter
Frenzied Member
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
-
Dec 28th, 2011, 08:51 AM
#4
Re: POISSON in TSQL
How good are you in C#?
I found this example, but it is in C#....
-
Dec 28th, 2011, 05:44 PM
#5
Hyperactive Member
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
-
Jan 3rd, 2012, 04:27 AM
#6
Thread Starter
Frenzied Member
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?
-
Jan 3rd, 2012, 05:13 AM
#7
Re: POISSON in TSQL
Originally Posted by FishGuy
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.
-
Jan 3rd, 2012, 08:30 AM
#8
Thread Starter
Frenzied Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|