Thanks Om,
I also got some info on net. Need to create SQL UDF.
set nocount on
declare @n int
create table #lr (x real not null, y real not null)
--insert sample data
insert into #lr values (2005,5.620400866)
insert into #lr values (2006,5.638354669)
insert into #lr values (2007,5.659482216)
insert into #lr values (2008,5.676753802)
insert into #lr values (2009,5.697093487)
select @n=count(*) from #lr --this is just for convenience, you can substitute count(*) for @n in the code
--meat of the code begins here
select
((@n * sum(x*y)) - (sum(x)*sum(y)))/
((@n * sum(Power(x,2)))-Power(Sum(x),2)) AS Slope,
avg(y) - ((@n * sum(x*y)) - (sum(x)*sum(y)))/
((@n * sum(Power(x,2)))-Power(Sum(x),2)) * avg(x) as Intercept
from #lr
drop table #lr
|