Ver Mensaje Individual
  #2  
Antiguo 03-12-2010
Avatar de ecfisa
ecfisa ecfisa is offline
Moderador
 
Registrado: dic 2005
Ubicación: Tres Arroyos, Argentina
Posts: 10.508
Reputación: 36
ecfisa is a splendid one to beholdecfisa is a splendid one to beholdecfisa is a splendid one to beholdecfisa is a splendid one to beholdecfisa is a splendid one to beholdecfisa is a splendid one to beholdecfisa is a splendid one to behold
Hola pedro.

Probá de este modo:
Código SQL [-]
CREATE PROCEDURE P_VR_INCAPACIDAD(COMP_BAS DOUBLE PRECISION, DIAS_INCAP DOUBLE PRECISION)
RETURNS (VR_INCAP DOUBLE PRECISION)
AS
BEGIN
  VR_INCAP = CAST((COMP_BAS/30) * DIAS_INCAP AS DOUBLE PRECISION);
END

Saludos .
Responder Con Cita