SELECT
    ROW_NUMBER() OVER(ORDER BY tturno)+@idturno as IDTurno,mci.IDCaja as IDCaja,@idestado as IDEstado,@idlocal as IDLocal,tturno as NUmeroTurno,fInicial as FechaInicial,ffinal as FechaFinal,tusuario as Usuario,lCierre as EstadoCierre,0 as EfectivoSoles,0 as EfectivoDolares,0 as Tarjeta0, 0 as Tarjeta2, 0 as Tarjeta3, 0 as Tarjeta4,   0 as Tarjeta5, 0 as Tarjeta6, 0 as Tarjeta7, 0 as Tarjeta8, 0 as Cheque, 0 as OtroPago0, 0 as OtroPago2,0 as OtroPago3,0 as OtroPago4,0 as OtroPago5,0 as OtroPago6,0 as OtroPago7,0 as OtroPago8,0 as OtroPago9,0 as OtroPago00,0 as CuentasCobrar,0 as CobradoOtroTurno,0 as TotalVenta,0 as PaloteoVenta,0 as CuentasCorrientes,0 as Cortesia,   0 as PaloteoProduccion,0 as EfectivoFisicoSoles,0 as EfectivoFisicoDolares,0 as EgresosSoles,0 as EgresosDolares,0 as RemesaSoles,0 as RemesaDolares,'' as Observacion,
    tobservacion as ObservacionCajero,tUsuario as UsuarioCajero,tadministrador as ObservacionAdministrador,tAdministradorUsuario as UsuarioAdministrador,
    tControler as ObservacionControler, tcontrolerusuario as UsuarioControler,1 as IDUsuario,GETDATE()as FechaRegistro
FROM
    INFORESTMETROCANTOGRANDE.dbo.mturno mt WITH(NOLOCK)
    inner join mc_ventas.dbo.MCCDC_CAJA_INTERMEDIA mci on (mt.tCaja=mci.tCaja and @idlocal=mci.IDLocal)
WHERE
    mt.lReplica=0 order by ROW_NUMBER() OVER(ORDER BY tturno) asc