Adecuación para calculo de indicadores de totales de alumnos en página Principal
/* --------------------------------------------------------------------------------------------------------------
FECHA | AUTOR |DESCRIPCION
24/Mar/2017 | Luis Bernal |
--------------------------------------------------------------------------------------------------------------*/
----------------------------INICIO PROCEDIMIENTO ------------------------
IF OBJECT_ID('spIndEstatusAlumnosActuales', 'P') IS NOT NULL
DROP PROC spIndEstatusAlumnosActuales
GO
CREATE PROCEDURE spIndEstatusAlumnosActuales
@dFechaI DATETIME,
@dFechaF DATETIME,
@idPlantel SMALLINT
AS
BEGIN
SET NOCOUNT ON;
SET LANGUAGE spanish;
SET DATEFORMAT MDY;
SET DATEFIRST 7;
DECLARE @bCampus BIT;
SELECT @bCampus = bCampus FROM dbo.Cat_Planteles WHERE idPlantel = @idPlantel
IF @bCampus = 1
BEGIN
SELECT ci.idEstatusInsc ,
cei.sEstatus
FROM dbo.Ctrl_Periodos AS cp
INNER JOIN dbo.Ctrl_Inscripciones AS ci ON ci.iFolioPeriodo = cp.iFolio
INNER JOIN dbo.Cat_EstatusInsc AS cei ON cei.idEstatus = ci.idEstatusInsc
WHERE @dFechaI BETWEEN cp.dFechaInicial AND cp.dFechaFinal AND ci.idPlantel = @idPlantel;
END
ELSE
BEGIN
SELECT ci.idEstatusInsc ,
cei.sEstatus
FROM dbo.Ctrl_Periodos AS cp
INNER JOIN dbo.Ctrl_Inscripciones AS ci ON ci.iFolioPeriodo = cp.iFolio
INNER JOIN dbo.Cat_EstatusInsc AS cei ON cei.idEstatus = ci.idEstatusInsc
WHERE @dFechaI BETWEEN cp.dFechaInicial AND cp.dFechaFinal;
END
END;