Diagnóstico contabilidad ICG (4) — ¿dónde está la conta 2026?

1) Gestión: rango de fechas en ventas y compras

SELECT 'FACTURASVENTA' AS tabla, COUNT(*) AS n, MIN(FECHA) AS minf, MAX(FECHA) AS maxf FROM FACTURASVENTA
 UNION ALL
 SELECT 'FACTURASCOMPRA', COUNT(*), MIN(FECHA), MAX(FECHA) FROM FACTURASCOMPRA
tablanminfmaxf
FACTURASVENTA75045192014-11-12 00:00:00.0002026-11-21 00:00:00.000
FACTURASCOMPRA3707912014-01-01 00:00:00.0002026-11-20 00:00:00.000

2 filas


2) Barrido de DIARIOAPUNTES en todas las bases locales

SET NOCOUNT ON;
IF OBJECT_ID('tempdb..#r') IS NOT NULL DROP TABLE #r;
CREATE TABLE #r (basedatos sysname, apuntes int, minf datetime, maxf datetime);
DECLARE @db sysname, @sql nvarchar(max);
DECLARE c CURSOR FOR
  SELECT name FROM sys.databases WHERE database_id > 4 AND state = 0;
OPEN c; FETCH NEXT FROM c INTO @db;
WHILE @@FETCH_STATUS = 0
BEGIN
  BEGIN TRY
    SET @sql = 'INSERT INTO #r SELECT ''' + @db + ''', COUNT(*), MIN(FECHA), MAX(FECHA) FROM [' + @db + '].dbo.DIARIOAPUNTES';
    EXEC sp_executesql @sql;
  END TRY BEGIN CATCH END CATCH
  FETCH NEXT FROM c INTO @db;
END
CLOSE c; DEALLOCATE c;
SELECT basedatos, apuntes, minf, maxf FROM #r ORDER BY maxf DESC;
basedatosapuntesminfmaxf
C20210301625862021-01-01 00:00:00.0003025-01-10 00:00:00.000
C20230013556462002-10-16 00:00:00.0002525-04-01 00:00:00.000
C20230415955342004-10-31 00:00:00.0002525-03-31 00:00:00.000
CSANTALO698672014-01-01 00:00:00.0002216-02-19 00:00:00.000
PLAZA865212014-08-19 00:00:00.0002216-02-19 00:00:00.000
CBONANOVA560432016-01-01 00:00:00.0002188-10-31 00:00:00.000
CMASQCARNE211182016-01-02 00:00:00.0002188-10-31 00:00:00.000
CMUNTANER335132016-01-01 00:00:00.0002108-03-22 00:00:00.000
C2023047298082023-01-01 00:00:00.0002025-12-31 00:00:00.000
C202205426502022-01-01 00:00:00.0002024-04-26 00:00:00.000
C20220413177072022-01-01 00:00:00.0002022-12-31 00:00:00.000
C2022047699862022-01-01 00:00:00.0002022-12-31 00:00:00.000
C20220011815202022-01-01 00:00:00.0002022-12-31 00:00:00.000
C20220042362022-01-01 00:00:00.0002022-10-20 00:00:00.000
C20200412088132020-01-01 00:00:00.0002022-09-30 00:00:00.000
C20210413660632021-01-01 00:00:00.0002021-12-31 00:00:00.000
C2021047744092021-01-01 00:00:00.0002021-12-31 00:00:00.000
C202105420211822021-06-30 00:00:00.0002021-12-31 00:00:00.000
C20210012154082021-01-01 00:00:00.0002021-12-31 00:00:00.000
C2021004704082021-01-01 00:00:00.0002021-12-31 00:00:00.000
CASATIO2212020-11-25 00:00:00.0002021-02-05 00:00:00.000
C2020047585522020-01-01 00:00:00.0002020-12-31 00:00:00.000
C20200011963272020-01-01 00:00:00.0002020-12-31 00:00:00.000
C20200041143292020-01-01 00:00:00.0002020-12-31 00:00:00.000
C2020030172232020-01-01 00:00:00.0002020-12-31 00:00:00.000
C20190011994532019-01-01 00:00:00.0002019-12-31 00:00:00.000
C20190041098792019-01-01 00:00:00.0002019-12-31 00:00:00.000
C2019030207742019-01-01 00:00:00.0002019-12-31 00:00:00.000
C20190411594362019-01-01 00:00:00.0002019-12-31 00:00:00.000
C2019047622632019-01-01 00:00:00.0002019-12-31 00:00:00.000
TAMBOARCE201634122016-04-06 00:00:00.0002019-11-22 00:00:00.000
C20180011978532018-01-01 00:00:00.0002018-12-31 00:00:00.000
C2018004919352011-12-15 00:00:00.0002018-12-31 00:00:00.000
C2018030175372018-01-01 00:00:00.0002018-12-31 00:00:00.000
C20180411612632018-01-01 00:00:00.0002018-12-31 00:00:00.000
C2018047965732018-01-01 00:00:00.0002018-12-31 00:00:00.000
C20180029282018-01-01 00:00:00.0002018-07-05 00:00:00.000
CEDGAR20182622017-12-28 00:00:00.0002018-06-20 00:00:00.000
ROSAESTRELLA6342017-09-13 00:00:00.0002018-04-01 00:00:00.000
CTAMBOSL_2016592242017-01-02 00:00:00.0002018-01-31 00:00:00.000
CKCH_INVERSORY_2017870822017-01-14 00:00:00.0002017-12-31 00:00:00.000
C20170012161312017-01-01 00:00:00.0002017-12-31 00:00:00.000
C2017002172492017-01-01 00:00:00.0002017-12-31 00:00:00.000
C2017004905962017-01-01 00:00:00.0002017-12-31 00:00:00.000
C2017030126962017-01-01 00:00:00.0002017-12-31 00:00:00.000
CPRUEBAS_KACHA_20141132014-08-19 00:00:00.0002017-09-14 00:00:00.000
CPADUA562016-01-26 00:00:00.0002017-04-21 00:00:00.000
CFRANQUICIAS3932016-09-21 00:00:00.0002017-01-12 00:00:00.000
CKUMATO201635432016-01-01 00:00:00.0002016-12-31 00:00:00.000
CBONA2016743662016-01-01 00:00:00.0002016-12-31 00:00:00.000
C20160011649892016-01-01 00:00:00.0002016-12-31 00:00:00.000
C201600274062016-01-01 00:00:00.0002016-12-31 00:00:00.000
C2015001133502015-01-01 00:00:00.0002015-12-31 00:00:00.000
C201500242015-12-31 00:00:00.0002015-12-31 00:00:00.000
CDYLAN_20158882015-09-13 00:00:00.0002015-12-31 00:00:00.000
CKACHA_20146902014-08-19 00:00:00.0002014-12-31 00:00:00.000
CREDLY20160
Consolidado_kch0
CDYLANNOU20170
CDYLANNOVA202120210
OBRADOR0
CTAMBOARCE0
CTAMBOSL0
C_TAMBO_SL0
C1KUMATO20160
C20170470
CBONA0

67 filas


3) Columnas de NOMINAS / NOMINASENLACECONTA

SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE
 FROM INFORMATION_SCHEMA.COLUMNS
 WHERE TABLE_NAME IN ('NOMINAS','NOMINASENLACECONTA')
 ORDER BY TABLE_NAME, ORDINAL_POSITION
TABLE_NAMECOLUMN_NAMEDATA_TYPE
NOMINASCODEMPLEADOint
NOMINASMESint
NOMINASANYOint
NOMINASTOTAL_DEVENGADOfloat
NOMINASRETIRPFfloat
NOMINASSSEMPLEADOfloat
NOMINASSSEMPRESAfloat
NOMINASCONTABILIZADObit
NOMINASENLACE_EMPRESAint
NOMINASENLACE_EJERCICIOint
NOMINASENLACE_ASIENTOint
NOMINASENLACE_USUARIOnvarchar
NOMINASENLACECONTAMESint
NOMINASENLACECONTAANYOint
NOMINASENLACECONTAENLACE_EMPRESAint
NOMINASENLACECONTAENLACE_EJERCICIOint
NOMINASENLACECONTAENLACE_ASIENTOint
NOMINASENLACECONTAENLACE_USUARIOnvarchar

18 filas


Fin. Recuerda borrar diag_contab4.php al terminar.