CREATE PROCEDURE update_growth  AS

declare @ticker varchar( 50 )
declare @start decimal( 18 , 6 )
declare @stop decimal( 18 , 6 )
declare @stock  varchar( 50 )
declare @lastdate datetime

SELECT  top  1  @lastdate=startdate FROM minutes WHERE DATEDIFF(DAY, startdate, GETDATE()) >  1  order by id desc


DECLARE cur CURSOR FOR
select distinct alias, stock from tickers
OPEN cur
FETCH NEXT FROM cur
into @ticker, @stock
if @@fetch_status= 0  
begin

SELECT TOP  1  startdate, @stop=stop FROM minutes m 
WHERE ((DATEDIFF(DAY, m.startdate, @lastdate) <  1 )
AND (ticker = @ticker) and (stock=@stock)) ORDER BY startdate desc

SELECT TOP  1  startdate, @start=start FROM minutes m 
WHERE ((DATEDIFF(DAY, m.startdate, @lastdate) <  1 )
AND (ticker = @ticker) and (stock=@stock)) ORDER BY startdate

if (@stop<> 0 )
begin
update tickers set growth=(@stop-@start)/@stop
end
WHILE @@FETCH_STATUS =  0 
BEGIN
FETCH NEXT FROM cur
if @@fetch_status= 0  
begin
FETCH NEXT FROM cur
into @ticker, @stock
if @@fetch_status= 0  
begin

SELECT TOP  1  startdate, @stop=stop FROM minutes m 
WHERE ((DATEDIFF(DAY, m.startdate, @lastdate) <  1 )
AND (ticker = @ticker) and (stock=@stock)) ORDER BY startdate desc

SELECT TOP  1  startdate, @start=start FROM minutes m 
WHERE ((DATEDIFF(DAY, m.startdate, @lastdate) <  1 )
AND (ticker = @ticker) and (stock=@stock)) ORDER BY startdate

if @stop<> 0 
begin
update tickers set growth=(@stop-@start)/@stop
end
end
END
end
CLOSE cur
DEALLOCATE cur