Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lopaka
Starting Member
48 Posts |
 Posted - 2007-06-05 : 00:19:52
|
| Can anybody assist me or know of a cubic spline function/stored procedure?Thank youRobert R. Barnes |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-05 : 01:36:08
|
here's a curve fitting function from Peso, but no cubic spline, you'll have to beg him to expand it.  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=77311anyway seems to me this type of math is better done in compiled code.
www.elsasoft.org |
 |
|
|
Lopaka
Starting Member
48 Posts |
Posted - 2007-06-05 : 02:46:19
|
| I did do the spline in VB but i need to run it on over Ten Billion records. I was hoping it would be faster on my server...:)Robert R. Barnes |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-05 : 02:53:52
|
if you already have the VB code it should be a fairly simple matter to modify Peso's function to add spline fitting, no?10 billion rows is a lot! do you really need to fit all the points though? seems like a fitting a random sample from this large set might be sufficient.
elsasoft.org |
|
|
|
|
|
|
Cubic Spline in a Function