I have a need to use a TSQL function in a stored procedure that does a calculation for a fair number of rows. Function is Poisson's. I need to give it three parameters and get one number back. This for about 200Krows.

My choices are put the data 56KRows at a time into Excel which I think is tedious and archaic.

Somehow, and this is the point of the post, link to just that function and maybe put it into a User defined function in SQL or link to a CLR library or something.

Help, guidance, sample code, anything would be really appreciated.

 

What do you mean Function is Poisson? Are you generating poisson-distributed random variables, or calculating Maximum Likelyhood or what? The answer I'd give would be entirely different depending on what you were trying to achieve.