select IFNULL(sum(DeCa_Monto),0) as TotalAport
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (2,3,17,18,22,23,24,26)
and DeCa_Estatus = 1
select IFNULL(sum(DeCa_Monto),0) as TotalAport
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (2,3,17,18,22,23,24,26)
and DeCa_Estatus = 1
and Deca_Fecha < DATE_ADD('#dateformat(Fecha,"yyyy-mm-dd")#',INTERVAL 1 DAY )
select IFNULL(sum(DeCa_Monto),0) as TotalAport
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (2,3,22,23)
and DeCa_Estatus = 1
select IFNULL(sum(DeCa_Monto),0) as TotalAport
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (17,18,24,26)
and DeCa_Estatus = 1
select Asig_PrecioCompra
from Asignacion
where Asig_AsignacionId = #AsignacionId#
select IFNULL(sum(DeCa_Monto),0) as TotalAport
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (2,3,17,18,22,23,24,26)
and DeCa_Estatus = 1
select Asig_PrecioCompra
from Asignacion
where Asig_AsignacionId = #AsignacionId#
select IFNULL(sum(DeCa_Monto),0) as TotalAport
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (2,3,17,18,22,23,24,26)
and DeCa_Estatus = 1
and Deca_Fecha < DATE_ADD('#dateformat(Fecha,"yyyy-mm-dd")#',INTERVAL 1 DAY )
select max(DeCa_Fecha) as UltimaFecha
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (2,3,17,18,22,23,24,26)
and DeCa_Estatus = 1
select max(DeCa_Fecha) as UltimaFecha
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (2,3,17,18,22,23,24,26)
and DeCa_Estatus = 1
and Deca_Fecha < DATE_ADD('#dateformat(Fecha,"yyyy-mm-dd")#',INTERVAL 1 DAY )
select Asig_Enganche
from Asignacion
where Asig_AsignacionId = #AsignacionId#
select IFNULL(sum(DeCa_Monto),0) as Enganche
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (2,22)
and DeCa_Estatus = 1
select Asig_Enganche
from Asignacion
where Asig_AsignacionId = #AsignacionId#
select IFNULL(sum(DeCa_Monto),0) as Enganche
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (2,22)
and DeCa_Estatus = 1
select Asig_Fecha, Asig_Enganche, Asig_PagoSemanal, Asig_PrecioCompra, Asig_DiasEnganche, Asig_FrecuenciaPago, asig_IdMigracion
from Asignacion
where Asig_AsignacionId = #AsignacionId#
select IFNULL(sum(DeCa_Monto),0) as Enganche, Max(Deca_Fecha) as FechaEng
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (2,22)
and DeCa_Estatus = 1
select IFNULL(sum(DeCa_Monto),0) as TotalAport
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (2,3,22,23)
and DeCa_Estatus = 1
select Asig_PrecioCompra
from Asignacion
where Asig_AsignacionId = #AsignacionId#
select IFNULL(sum(DeCa_Monto),0) as TotalAport
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (2,3,22,23)
and DeCa_Estatus = 1
and Deca_Fecha < DATE_ADD('#dateformat(Fecha,"yyyy-mm-dd")#',INTERVAL 1 DAY )
select min(DeCa_Fecha) as Fecha1er
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (3,23)
and DeCa_Estatus = 1
medidaresultado=StructNew();
medidaresultado.Estatus=0;
medidaresultado.Fecha="2001-01-01";
medidaresultado.Monto=0;
select ifnull(sum(Deca_Monto),0) as Monto, min(DeCa_Fecha) as Fecha
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (12,25)
and DeCa_Estatus = 1
medidaresultado.Estatus=resultado;
medidaresultado.Fecha=fecha;
medidaresultado.Monto=monto;
select Adqu_Enganche
from Adquisicion
where Adqu_AdquisicionId = #AdquisicionId#
select IFNULL(sum(DeCa_Monto),0) as Enganche
from Gasto inner join Detalle_caja
on DeCa_GastoId = Gast_GastoId
and Gast_AdquisicionId = #AdquisicionId#
and Gast_SubCategoriaId in (19)
and DeCa_Estatus = 1
select sum(DeCa_Monto) as TotalPago
from Gasto inner join Detalle_caja
on DeCa_GastoId = Gast_GastoId
and Gast_AdquisicionId = #AdquisicionId#
and Gast_SubCategoriaId in (19,20)
and DeCa_Estatus = 1
select ifnull(sum(AdPa_Monto),0) as TotalPago2 from adquisicion_pago
where AdPa_AdquisicionId = #AdquisicionId#
and AdPa_Estatus = 1
and AdPa_GastoId = 0
select Adqu_Precio
from Adquisicion
where Adqu_AdquisicionId = #AdquisicionId#
select ifnull(sum(DeCa_Monto),0) as TotalPago
from Gasto inner join Detalle_caja
on DeCa_GastoId = Gast_GastoId
and Gast_AdquisicionId = #AdquisicionId#
and Gast_SubCategoriaId in (19,20)
and DeCa_Estatus = 1
select ifnull(sum(AdPa_Monto),0) as TotalPago2 from adquisicion_pago
where AdPa_AdquisicionId = #AdquisicionId#
and AdPa_Estatus = 1
and AdPa_GastoId = 0
select Adqu_Precio
from Adquisicion
where Adqu_AdquisicionId = #AdquisicionId#
select ifnull(sum(DeCa_Monto),0) as TotalPago
from Gasto inner join Detalle_caja
on DeCa_GastoId = Gast_GastoId
and Gast_AdquisicionId = #AdquisicionId#
and Gast_SubCategoriaId in (19,20)
and DeCa_Estatus = 1
and Deca_Fecha < DATE_ADD('#dateformat(Fecha,"yyyy-mm-dd")#',INTERVAL 1 DAY )
select ifnull(sum(AdPa_Monto),0) as TotalPago2 from adquisicion_pago
where AdPa_AdquisicionId = #AdquisicionId#
and AdPa_Estatus = 1
and AdPa_GastoId = 0
and AdPa_Fecha < DATE_ADD('#dateformat(Fecha,"yyyy-mm-dd")#',INTERVAL 1 DAY )
order by AdPa_Numero
select AdEj_TotalMonto
from adquisicion_ejidatario
where AdEj_AdquisicionId = #AdquisicionId#
and AdEj_EjidatarioId = #EjidatarioId#
select ifnull(sum(DeCa_Monto),0) as TotalPago
from Gasto inner join Detalle_caja on DeCa_GastoId = Gast_GastoId
inner join adquisicion_pago on AdPa_GastoId = Gast_GastoId
and Gast_AdquisicionId = #AdquisicionId#
and Gast_SubCategoriaId in (20)
and AdPa_EjidatarioId = #EjidatarioId#
and DeCa_Estatus = 1
and Deca_Fecha < DATE_ADD('#dateformat(Fecha,"yyyy-mm-dd")#',INTERVAL 1 DAY )
select ifnull(sum(AdPa_Monto),0) as TotalPago2 from adquisicion_pago
where AdPa_AdquisicionId = #AdquisicionId#
and AdPa_EjidatarioId = #EjidatarioId#
and AdPa_Estatus = 1
and AdPa_GastoId = 0
and AdPa_Fecha < DATE_ADD('#dateformat(Fecha,"yyyy-mm-dd")#',INTERVAL 1 DAY )
order by AdPa_Numero
select Adqu_Fecha, Adqu_Enganche, Adqu_PagoMensual
from Adquisicion
where Adqu_AdquisicionId = #AdquisicionId#
select ifnull(sum(DeCa_Monto),0) as Enganche
from Gasto inner join Detalle_caja
on DeCa_GastoId = Gast_GastoId
and Gast_AdquisicionId = #AdquisicionId#
and Gast_SubCategoriaId in (19)
and DeCa_Estatus = 1
select ifnull(sum(DeCa_Monto),0) as TotalPago
from Gasto inner join Detalle_caja
on DeCa_GastoId = Gast_GastoId
and Gast_AdquisicionId = #AdquisicionId#
and Gast_SubCategoriaId in (19,20)
and DeCa_Estatus = 1
select ifnull(sum(AdPa_Monto),0) as TotalPago2 from adquisicion_pago
where AdPa_AdquisicionId = #AdquisicionId#
and AdPa_Estatus = 1
and AdPa_GastoId = 0
order by AdPa_Numero
select max(DeCa_Fecha) as Fecha
from Gasto inner join Detalle_caja
on DeCa_GastoId = Gast_GastoId
and Gast_AdquisicionId = #AdquisicionId#
and Gast_SubCategoriaId in (19)
and DeCa_Estatus = 1
select max(DeCa_Fecha) as UltimaFecha
from Gasto inner join Detalle_caja
on DeCa_GastoId = Gast_GastoId
and Gast_AdquisicionId = #AdquisicionId#
and Gast_SubCategoriaId in (19,20)
and DeCa_Estatus = 1
select Lote_LoteId, Lote_Lote, Lote_Superficie, Lote_Esquina, Frac_PrecioCreditom2, Frac_PrecioContadom2, Frac_Superficie, Frac_Comision,
Frac_Enganche, Frac_AumentoEsquina, Frac_TipoAumentoEsquina, Frac_PagoSemanal, Frac_AniosPago
from Lote inner join Manzana on Manz_ManzanaId = Lote_ManzanaId
inner join Fraccionamiento on Frac_FraccionamientoId = Manz_FraccionamientoId
where Lote_LoteId = #id#
select *
from equivalencia_banorte
select * from QryRef
where Valor = '#mid(Referencia,i,1)#'
select IFNULL(sum(DeCa_Monto),0) as TotalPagoInte
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (43)
and DeCa_Estatus = 1
select IFNULL(sum(DeCa_Monto),0) as TotalPagoInteMor
from Aportacion inner join Detalle_caja
on DeCa_AportacionId = Apor_AportacionId
and Apor_AsignacionId = #AsignacionId#
and Apor_SubCategoriaId in (44)
and DeCa_Estatus = 1
Gestora de Vivienda