cursor

hi

i need to put fetch next in my cursor.its goig endless.

declare @P1 nvarchar(32)
declare @mtd2 float


declare c1 CURSOR FOR 
select account, MTD from #temp2


open c1

FETCH NEXT FROM c1 
INTO @P1,@mtd2



WHILE @@FETCH_STATUS = 0
begin



if(@mtd2 IS NULL ) 
BEGIN

declare @IRR2 float







EXEC pdashboard





select @IRR2 = IRR from pdashboard

SELECT @IRR2 as Last1month


END

ELSE 
BEGIN
select @mtd2 as last2month 






END

fetch next from c1 into @P1,@MTD2


END

where do i need to put ?

Just out of curiosity, what is it you're trying to accomplish? Depending on what your needs are, might be easier implementation than cursor.

got solve .thanks