"Enric" wrote:

> Dear all,
>
> I was wondering how do I for obtain the total for the field 'parcial' in the
> same query, of course:
>
> SELECT MONTH(DIA_HORAESCRITURA) AS MES,DAY(DIA_HORAESCRITURA) AS DIA,
> COUNT(*) AS partial
> FROM ABS_DIARIOHISTO
> WHERE DIA_SUCURSAL = 81
> GROUP BY MONTH(DIA_HORAESCRITURA),DAY(HORAESCRITURA)
> ORDER BY MES,DIA
>
>
> DDL:
>
> CREATE TABLE [ABS_DiarioHisto] (
>     [DIA_CodigoApunte] [int] NOT NULL ,
>     [DIA_MaquinaFisica] [varchar] (36) COLLATE Traditional_Spanish_CI_AS NOT
> NULL ,
>     [DIA_HoraEscritura] [datetime] NULL ,
>     [DIA_Sucursal] [int] NULL ,
>     [DIA_Puesto] [smallint] NULL ,
>     [DIA_Usuario] [char] (6) COLLATE Traditional_Spanish_CI_AS NULL ,
>     [DIA_FechaOper] [datetime] NULL ,
>     [DIA_HoraOpera] [varchar] (8) COLLATE Traditional_Spanish_CI_AS NULL ,
>     [DIA_FechaConta] [datetime] NULL ,
>     [DIA_Comentarios] [varchar] (255) COLLATE Traditional_Spanish_CI_AS NULL ,
>     [DIA_CodOper] [varchar] (6) COLLATE Traditional_Spanish_CI_AS NULL ,
>     [DIA_NumCuen] [varchar] (10) COLLATE Traditional_Spanish_CI_AS NULL ,
>     [DIA_Importe] [float] NULL ,
>     [DIA_Predisp] [smallint] NULL ,
>     [DIA_NumDocum] [varchar] (30) COLLATE Traditional_Spanish_CI_AS NULL ,
>     [DIA_ClCajero] [smallint] NULL ,
>     [DIA_Vise] [varchar] (2) COLLATE Traditional_Spanish_CI_AS NULL ,
>     [DIA_NumHost] [int] NULL ,
>     [DIA_CodError] [int] NULL ,
>     [DIA_Anulada] [smallint] NULL ,
>     [DIA_TipoOper] [int] NULL ,
>     [DIA_NumOper] [int] NULL ,
>     [DIA_FormatoTXS] [varchar] (15) COLLATE Traditional_Spanish_CI_AS NULL ,
>     [DIA_CodEntidad] [int] NULL ,
>     [DIA_CodOficina] [int] NULL ,
>     [DIA_CasoEuro] [tinyint] NULL ,
>     [DIA_ImporteB] [float] NULL ,
>     [DIA_CodISO] [varchar] (4) COLLATE Traditional_Spanish_CI_AS NULL ,
>     [DIA_CuentaContrapart] [varchar] (16) COLLATE Traditional_Spanish_CI_AS NULL
> ) ON [PRIMARY]
> GO
>
>
>
>
> Thanks in advance and best regards,
> Enric

"Enric" wrote:

> sorry, as usual, I haven't enough patience...
>
> select sum(total) from (
> SELECT MONTH(DIA_HORAESCRITURA) AS MES,DAY(DIA_HORAESCRITURA) AS DIA,
> count(*) as total
> FROM ABS_DIARIOHISTO  WHERE DIA_SUCURSAL = 81 
> GROUP BY MONTH(DIA_HORAESCRITURA),DAY(DIA_HORAESCRITURA)
> ) D
>
>
> "Enric" wrote:
>
> > Dear all,
> >
> > I was wondering how do I for obtain the total for the field 'parcial' in the
> > same query, of course:
> >
> > SELECT MONTH(DIA_HORAESCRITURA) AS MES,DAY(DIA_HORAESCRITURA) AS DIA,
> > COUNT(*) AS partial
> > FROM ABS_DIARIOHISTO
> > WHERE DIA_SUCURSAL = 81
> > GROUP BY MONTH(DIA_HORAESCRITURA),DAY(HORAESCRITURA)
> > ORDER BY MES,DIA
> >
> >
> > DDL:
> >
> > CREATE TABLE [ABS_DiarioHisto] (
> >     [DIA_CodigoApunte] [int] NOT NULL ,
> >     [DIA_MaquinaFisica] [varchar] (36) COLLATE Traditional_Spanish_CI_AS NOT
> > NULL ,
> >     [DIA_HoraEscritura] [datetime] NULL ,
> >     [DIA_Sucursal] [int] NULL ,
> >     [DIA_Puesto] [smallint] NULL ,
> >     [DIA_Usuario] [char] (6) COLLATE Traditional_Spanish_CI_AS NULL ,
> >     [DIA_FechaOper] [datetime] NULL ,
> >     [DIA_HoraOpera] [varchar] (8) COLLATE Traditional_Spanish_CI_AS NULL ,
> >     [DIA_FechaConta] [datetime] NULL ,
> >     [DIA_Comentarios] [varchar] (255) COLLATE Traditional_Spanish_CI_AS NULL ,
> >     [DIA_CodOper] [varchar] (6) COLLATE Traditional_Spanish_CI_AS NULL ,
> >     [DIA_NumCuen] [varchar] (10) COLLATE Traditional_Spanish_CI_AS NULL ,
> >     [DIA_Importe] [float] NULL ,
> >     [DIA_Predisp] [smallint] NULL ,
> >     [DIA_NumDocum] [varchar] (30) COLLATE Traditional_Spanish_CI_AS NULL ,
> >     [DIA_ClCajero] [smallint] NULL ,
> >     [DIA_Vise] [varchar] (2) COLLATE Traditional_Spanish_CI_AS NULL ,
> >     [DIA_NumHost] [int] NULL ,
> >     [DIA_CodError] [int] NULL ,
> >     [DIA_Anulada] [smallint] NULL ,
> >     [DIA_TipoOper] [int] NULL ,
> >     [DIA_NumOper] [int] NULL ,
> >     [DIA_FormatoTXS] [varchar] (15) COLLATE Traditional_Spanish_CI_AS NULL ,
> >     [DIA_CodEntidad] [int] NULL ,
> >     [DIA_CodOficina] [int] NULL ,
> >     [DIA_CasoEuro] [tinyint] NULL ,
> >     [DIA_ImporteB] [float] NULL ,
> >     [DIA_CodISO] [varchar] (4) COLLATE Traditional_Spanish_CI_AS NULL ,
> >     [DIA_CuentaContrapart] [varchar] (16) COLLATE Traditional_Spanish_CI_AS NULL
> > ) ON [PRIMARY]
> > GO
> >
> >
> >
> >
> > Thanks in advance and best regards,
> > Enric