ok.

i change my fetch statement in this code.

still not working

declare @P1 nvarchar(32)

declare @mtd2 float

DECLARE @qtd float

declare @ytd float

declare c1 CURSOR FOR

select account,MTDTWR ,QTDTWR,YTDTWR from #temp1

open c1

FETCH NEXT FROM c1...

this is my complete code,why it snot working for so many rows,if there is only 1 row its working.

otherwise its just getting me last values.everything else is getting null.

declare @P1...

ok. i tried to put everwhere nothing is working

plz help

where should i put it

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...

i am also putting in if statement and after end of if,

nothing is working out.

where should i put

OK. I PUT FETCH_NEXT LIKE THIS

STILL NOT WORKING GOING 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 =...

ok.simple question.my cursor return one value that i need to take in temp table

simply i can insert into temp table(cursor return value using local variable)

thanks for the link,i got it

where should i put fetch_next in body

whats wrong with this code,i am getting values again and again.repeating

declare @P1 nvarchar(32)

declare @mtd2 float

...