exec(" insert into #d_detalle_operativo_diario_pba_v2
select mov_ax1,mov_ax2,mov_ax3,   mov_fecva, mov_fecop,
case when mov_d_h = 'D' then mov_imp * -1 else mov_imp end importe ,
0,0,0,0,'Conta','Conta','Conta','Conta','00000',mov_cta,
'61106'   from " + @tablaMov +  " with (NOLOCK) " + "
where mov_cta in ('540131020000','590401010000','690401010000')
and mov_ax2 like '02220%'
and mov_fecop <= " + @lastDay  + " ")

select mov_ax1,mov_ax2,mov_ax3,   mov_fecva, mov_fecop,

select mov_ax1,mov_ax2,mov_ax3,   mov_fecop, mov_fecva,

select mov_ax1,mov_ax2,mov_ax3,   mov_fecva, mov_fecop,

SELECT tra_aux1,  tra_aux2,  tra_aux3,

FROM   @tablaMov WITH (nolock)
LEFT JOIN @tablaTra WITH (nolock) ON mov_folio = tra_folio
LEFT JOIN cliente WITH (nolock)  ON tra_aux1 = cte_cliente

...    '42101'
FROM   @tablaMov WITH (nolock)
       LEFT JOIN @tablaTra WITH (nolock) ON mov_folio = tra_folio
       LEFT JOIN cliente WITH (nolock) ON tra_aux1 = cte_cliente
WHERE  mov_cta = '510301010000'
       AND mov_ax1 = '0100001779'
       AND tra_lugar NOT IN ( 'GDL-CON1', 'GUA-LSO' )
       AND mov_fecop <= @lastDay

...    '42101'
FROM   @tablaMov WITH (nolock)
       LEFT JOIN @tablaTra WITH (nolock) ON mov_folio = tra_folio
       LEFT JOIN cliente WITH (nolock) ON tra_aux1 = cte_cliente
WHERE  mov_cta IN ( '540101030000' )
       AND mov_ax1 = '0100001779'
       AND mov_fecop <= @lastDay

...    '42101'
FROM   @tablaMov WITH (nolock)
       LEFT JOIN @tablaTra WITH (nolock) ON mov_folio = tra_folio
       LEFT JOIN cliente WITH (nolock) ON tra_aux1 = cte_cliente
WHERE  mov_cta IN ( '590101000000', '690101000000' )
       AND tra_aux1 = '0100001779'
       AND tra_lugar NOT IN ( 'GDL-CON1', 'GUA-LSO' )
       AND mov_fecop <= @lastDay

SELECT CASE
 WHEN Substring(tra_aux1, 1, 2) NOT IN ( '00', ' ' ) THEN tra_aux1
 ELSE mov_ax1
 END movtra1,
 CASE
 WHEN Substring(tra_aux2, 1, 2) NOT IN ( '00', ' ' ) THEN tra_aux2
 ELSE mov_ax2
 END movtra2,
 CASE
 WHEN Substring(tra_aux3, 1, 2) NOT IN ( '00', ' ' ) THEN tra_aux3
 ELSE mov_ax3
 END movtra3,
 mov_fecop,
 mov_fecva,
 CASE
 WHEN mov_d_h = 'D' THEN mov_imp * -1
 ELSE mov_imp
 END importe,
 0,
 0,
 0,
 0,
 'Conta',
 'Conta',
 'Conta',
 'Conta',
 Rtrim(cte_actividad),
 mov_cta,
CASE
WHEN mov_cta = '510103000000' AND mov_ax1 = '0100305281' AND tra_lugar = 'CONTAB-8' AND mov_fecop <= @FechaAyer
THEN '41104'
WHEN mov_cta = '510103000000' AND mov_ax1 = '0100038678' AND tra_lugar IN ( 'GUA-GMS', 'CONTAB-9' ) AND mov_fecop <= @FechaAyer
THEN '41105'
WHEN mov_cta = '510301010000' AND mov_ax1 = '0100001779' AND tra_lugar NOT IN ( 'GDL-CON1', 'GUA-LSO' ) AND mov_fecop <= @FechaAyer
THEN '42101'
WHEN mov_cta IN ( '590101000000', '690101000000' ) AND tra_aux1 = '0100001779' AND tra_lugar NOT IN ( 'GDL-CON1', 'GUA-LSO' ) AND mov_fecop <= @FechaAyer
THEN '42101'
WHEN mov_cta IN ( '540101030000' ) AND mov_ax1 = '0100001779' AND mov_fecop <= @FechaAyer
THEN '42101'
WHEN mov_cta IN ( '540101030000' ) AND mov_ax1 = '0100305724' AND mov_fecop <= @FechaAyer
THEN '41106'
WHEN mov_cta IN ( '510102000000' ) AND mov_ax1 = '0100001793' AND tra_lugar IN ( 'GDL-AAV', 'GDL-JAZ' ) AND mov_fecop <= @FechaAyer
THEN '42102'
end as indicador
FROM @tablaMov WITH (nolock)
 LEFT JOIN @tablaTra WITH (nolock)
  ON mov_folio = tra_folio
 LEFT JOIN cliente WITH (nolock)
  ON tra_aux1 = cte_cliente
WHERE ( mov_cta = '510103000000' AND mov_ax1 = '0100305281' AND tra_lugar = 'CONTAB-8' AND mov_fecop <= @FechaAyer )
OR ( mov_cta = '510103000000' AND mov_ax1 = '0100038678' AND tra_lugar IN ( 'GUA-GMS', 'CONTAB-9' ) AND mov_fecop <= @FechaAyer )
OR ( mov_cta = '510301010000' AND mov_ax1 = '0100001779' AND tra_lugar NOT IN ( 'GDL-CON1', 'GUA-LSO' ) AND mov_fecop <= @FechaAyer )
OR ( mov_cta IN ( '590101000000', '690101000000' ) AND tra_aux1 = '0100001779' AND tra_lugar NOT IN ( 'GDL-CON1', 'GUA-LSO' ) AND mov_fecop <= @FechaAyer )
OR ( mov_cta IN ( '540101030000' ) AND mov_ax1 = '0100001779' AND mov_fecop <= @FechaAyer )
OR ( mov_cta IN ( '540101030000' ) AND mov_ax1 = '0100305724' AND mov_fecop <= @FechaAyer )
OR ( mov_cta IN ( '510102000000' ) AND mov_ax1 = '0100001793' AND tra_lugar IN ( 'GDL-AAV', 'GDL-JAZ' ) AND mov_fecop <= @FechaAyer )