Excel Functions in SQL server2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Excel Functions in SQL server2005

Excel Functions in SQL server2005

Rate Topic

Display Mode

Topic Options

Author

Message

sthirun

Posted Tuesday, September 01, 2009 9:48 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, December 21, 2012 1:13 PM
Points: 10, Visits: 126

I have a function in Excel- LINEST (Linear regression)
need to implement the same in SQl server 2005 if it is already not there( I do not see one)

Any help is greatly appreciated.

Thank you
Sree

Post #780834

Nabha

Posted Wednesday, September 02, 2009 1:50 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, August 02, 2011 3:36 AM
Points: 579, Visits: 1,803

I am just giving it a wild guess, I had not seen that in SQL Server atleast. Lets if someone knows about it. Otherwise what you can do is create a dot net assembly (CLR assembly). I guess it should be there in dot net library. Hope this helps.

---------------------------------------------------------------------------------

Post #781251

jatin-243645

Posted Friday, July 13, 2012 5:50 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 11:52 PM
Points: 29, Visits: 219

Hello,

Did you find any solution to this?
I also need to implement the Excel Linest() function in SQl server 2008.

Post #1329386

Lowell

Posted Friday, July 13, 2012 6:44 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 5:28 PM
Points: 11,627, Visits: 27,692

one of the links here:
http://charlottecredittechnology.blogspot.com/2008/11/sql-2008-excel-like-linest-function.html
seems to have a proc/function that i found after searching for sql server excel linest equivilent

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1329410

jatin-243645

Posted Friday, July 13, 2012 6:53 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 11:52 PM
Points: 29, Visits: 219

Thanks Lowell,
I have checked the link however I want Multiple Regression. Do you know how to achieve this ?

Post #1329415

Lowell

Posted Friday, July 13, 2012 7:02 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 5:28 PM
Points: 11,627, Visits: 27,692

not offhand, sorry; i only looked briefly at teh psot i showed you, and would have to read up on it;
it really does sound like soemthing i'd put into a CLR instead though.
i found theis link that implies they have a CLR for Linest / liniar regression:http://westclintech.com/XLeratorDBstatisticsDocumentation/tabid/159/Default.aspx
will that do teh job?

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1329422

« Prev Topic | Next Topic »

Permissions