Misael Magdiel Hau Pool
Ene 16, 2020
ERP
funcionesPRO - Buscar()
Invalid use of Null
SQL: SELECT TOP 300
Np_Cve_Nomina_Periodo AS CLAVE,
Np_Anio AS AÑO,
Np_Descripcion AS DESCRIPCION,
CASE Np_Tipo
WHEN '01' THEN 'DIARIO'
WHEN '02' THEN 'SEMANAL'
WHEN '03' THEN 'QUINCENAL'
WHEN '04' THEN 'MENSUAL'
WHEN '05' THEN 'ABIERTO' END AS PERIODO,
Np_Fecha_Inicial AS [FECHA INICIAL],
Np_Fecha_Final AS [FECHA FINAL],
Es_Cve_Estado AS ESTADO
FROM
Nomina_Periodo
WHERE
... Ver mas
![](https://community-mpro.s3.amazonaws.com/upload/2020/01/16/d9650b80ae3683ad20bc0eccefe6aadf.bmp)
![Felipe Cabrera](https://community-mpro.s3.amazonaws.com/upload/2018/05/27/bc65e649a2e37f1a767da825cf94102e.png)
![Isidro López Méndez](https://community-mpro.s3.amazonaws.com/upload/2019/06/21/44ac293a09dcd915b713f46defbfec18.jpg)
Hola Misael, podrias por favor ingresar al chat para revisar el tema?