Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Excel Functions in SQL server2005 Expand / Collapse
Author
Message
Posted Tuesday, September 01, 2009 9:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 4:50 AM
Points: 10, Visits: 144
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
Posted Wednesday, September 02, 2009 1:50 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr 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
Posted Friday, July 13, 2012 5:50 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 03, 2014 6:48 AM
Points: 31, Visits: 280
Hello,

Did you find any solution to this?
I also need to implement the Excel Linest() function in SQl server 2008.
Post #1329386
Posted Friday, July 13, 2012 6:44 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:26 PM
Points: 12,744, Visits: 31,071
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
Posted Friday, July 13, 2012 6:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 03, 2014 6:48 AM
Points: 31, Visits: 280
Thanks Lowell,
I have checked the link however I want Multiple Regression. Do you know how to achieve this ?
Post #1329415
Posted Friday, July 13, 2012 7:02 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:26 PM
Points: 12,744, Visits: 31,071
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 »

Add to briefcase

Permissions Expand / Collapse