|
Gracias por responder, solo deseo un DataSet, aqui esta la sintaxis del procedimiento:
ALTER PROCEDURE MiEnsayo
@Codi as char(6) output, @Nomb as varchar(30) output,
@Reci as varchar(12) output, @Valo as varchar(10) output,
@Apli as varchar(12) output, @Cons as varchar(10) output
AS
BEGIN
-- CORRESPONDE A LOS RECIBOS DEL DIA
declare Recibos cursor for
select ESTUDI,NOMBRE,cast(ID_REC as varchar(10)),
cast(VR_REC as varchar(10)),cast(FACTUR AS VARCHAR(10)),
cast(CONSIG as varchar(10)),ANULA
from DIARECI,ALUMNO
where ID_ALU = ESTUDI
order by ID_REC
declare @Anul as char(1)
open Recibos
fetch next from Recibos
into @Codi,@Nomb,@Reci,@Valo,@Apli,@Cons,@Anul
while( @@fetch_status = 0)
begin
set @Reci = 'RC ' + @Reci
If @Anul = '1'
begin
set @Valo = 'ANULADO'
set @Apli = ''
Set @Cons = ''
end
If @Anul = '0'
set @Apli = 'FA ' + @Apli
fetch next from Recibos
into @Codi,@Nomb,@Reci,@Valo,@Apli,@Cons,@Anul
end
close Recibos
deallocate Recibos
-- CORRESPONDE A LAS NOTAS CREDITO
set Notas cursor for
select ESTUDI,NOMBRE,cast(ID_NC as varchar(10)),
cast(VR_NC as varchar(10)),cast(FACTU AS VARCHAR(10)),ESTUDI
from NOTASCR,MESFACT,ALUMNO
where (ID_FAC = FACTU) and (ID_ALU = ESTUDI) and APLICA = 'P'
order by ID_NC
open Notas
fetch next from Notas
into @Codi,@Nomb,@Reci,@Valo,@Apli,@Cons
while( @@fetch_status = 0)
begin
set @Reci = 'NC ' + @Reci
set @Cons = ''
fetch next from Notas
into @Codi,@Nomb,@Reci,@Valo,@Apli,@Cons
end
close Notas
deallocate Notas
END
La consulta solo me arroja los registros de la parte CORRESPONDE A LAS NOTAS CREDITO, pero no me da los registros de CORRESPONDE A LOS RECIBOS DEL DIA, y deseo que arroje los registros de los RECIBOS y NOTAS.
|