CREATE PROCEDURE sp_remImportarCargasFamiliares
    @periodo       INT,                                                                                                                                                                                                                                                                                                                @mes           INT,
    @rut           INT,
    @cargaNormal   INT,
    @cargaInvalida INT,
    @cargaMaternal INT,
    @tramoCodigo   INT
AS
BEGIN
    SET NOCOUNT ON;

    UPDATE remTrabajadores
    SET
        CargaNormal       = @cargaNormal,
        CargaInvalida     = @cargaInvalida,
        CargaMaternal     = @cargaMaternal,
        tramoasigfamiliar = @tramoCodigo
    WHERE rut     = @rut
    AND periodo = @periodo
    AND mes     = @mes
    AND activo  = 1;
END