Hello folks, does anyone here know, how to create a cursor to a procedure from a function or procedure in MSSQL? Seems very simple, but i can't realise where is my falt, can you help me? Here's my code:

create function dbo.compararPeriodos(
@TABELA_ varchar( 40 ),
@CAMPO_ varchar( 40 ),
@CA_MODULO_ integer,
@CA_USUARIO_ varchar( 20 ),
@CN_ANO_REF_ integer,
@CN_MES_REF_ integer )
returns char( 1 )
as
begin
declare @cmd varchar( 4000 )
declare @status char( 1 )
declare @total numeric( 17, 2 )

declare cursorPesquisa CURSOR
for exec getTotalTabela
@TABELA_,
@CAMPO_,
@CA_MODULO_,
@CA_USUARIO_,
@CN_ANO_REF_,
@CN_MES_REF_

open cursorPesquisa

fetch from cursorPesquisa into
@total

CLOSE cursorPesquisa
DEALLOCATE cursorPesquisa

declare cursorCmp CURSOR
for select case
when @TOTAL >= @TOTAL - FAIXA_TOLERANCIA then 'o'
when @TOTAL >= @TOTAL - FAIXA_TOLERANCIA and @TOTAL <= @TOTAL - FAIXA_TOLERANCIA then 'a'
else 'p'
end
from SIE_MODULOS
where CA_MODULO = @CA_MODULO_

open cursorCmp

fetch from cursorCmp
into @status

CLOSE cursorCmp
DEALLOCATE cursorCmp

return @status
end


Regards,
LottaLava

You haven't said what the problem is. That sort of thing helps when trying to diagnose problems.

First thing I'd point out is that your cursors aren't using "fetch next from". I know that "fetch from" is legal syntax, but don't you have to have already moved onto a cursor row? You have to fetch next before you can fetch. fetch from just fetches the current row, and is usually not useful.

Neither of your cursors are iterating: seems very strange to use cursors to access the out params of a stored procedure or simple select. Why not just use the variables directly? If you're forgetting to iterate, the syntax is:The rest of what you've got looks right to me.