problem with cursor

[dinesh prasad]

I'm simply trying to divide each close1 column by 20, then insert
that value into the twentydayMA field. The query keeps on running
without finishing, even if I'm only using a single page of data. What
could be making this hang? To execute, I'm using exec tad778. I
thought about using another cursor to to handle the return values,
instead of trying to directly do so using the single cursor. Any
ideas?

Thanks..
Dinesh
CREATE procedure TAD778
as
declare

@close1 float,
@20dayMA float,
@date1 datetime,
@recordcount int

set nocount off

/* Delcare the cursor that is going to find all data */

Declare Cur_stocks Cursor
For select close1, date1, twentydayMA
from yhoo4

Open Cur_stocks

fetch Cur_stocks
into @close1, @date1, @20dayMA

select @recordcount = 0

while @@fetch_status = 0
Begin
Select "Copying record number" = @recordcount

Select @recordcount = @recordcount + 1

Select @20dayMA = @close1/20
from yhoo4

fetch Cur_stocks
into @close1, @date1, @20dayMA
insert into yhoo4(twentyday MA)
values(@20dayMA )
end
close Cur_stocks
deallocate Cur_stocks

set nocount on

return 0
GO

[David Portas]

Answered in microsoft.publi c.sqlserver.pro gramming
Please don't multi-post.

--
David Portas
------------
Please reply only to the newsgroup
--