Cursor

[yamiblancoc]

Código:

select distinct
       comp_cod = 'nom'+ replicate(0,5-len(a.codnom))+convert (varchar,a.codnom),
       pres_ano = a.anioa,
       comp_cod_doc = '-',
       comp_fecha = getdate(),
       comp_fecha_ing = getdate(),
       comp_concepto = 'Nomina: '+convert (varchar,a.codnom),
       comp_activo = 1,
       prec_cod = '-',
       comp_tot_filas = (select count(distinct c.codcon)
                         from SWNOMMSSQL000002.dbo.swnompta c
                        where c.codnom = a.codnom
                          and tipcon = 'A')+1,
       comp_tipo = 3,
       comp_ci = ''
  from SWNOMMSSQL000002.dbo.swnompta a left OUTER JOIN dbo.swnomhmv b on a.codnom= b.codnom
 where  mesa = 6
   and dia between  1 and 15
   and tipcon = 'A'
   and anioa = 2011
   and frecuencia  in (2,3,7,12,16,18)