"Laurent CLAUDEL" wrote:

> Hi,
>
> I have this query ( it is Ok with Sybase SQLServer)
>
> select  'Voie'=NVOI,'Mois'=datepart(mm,DPSTVOI)
> ,'Année'=datepart(yy,DPSTVOI),'Période'=CPST,'Nombre'=count(NVOI)
> from HREH3M
> group by CPST,NVOI,datepart(yy,DPSTVOI),datepart(mm,DPSTVOI)
> order by CPST,NVOI,datepart(yy,DPSTVOI),datepart(mm,DPSTVOI)
> compute sum(count(NVOI)) by CPST,NVOI,datepart(yy,DPSTVOI)
>
>
> I want to migrate it under MS SQLServer 2000, but I have this error message
> :
> Serveur : Msg 8120, Niveau 16, État 1, Ligne 1
> Column 'HREH3M.DPSTVOI' is invalid in the select list because it is not
> contained in either an aggregate function or the GROUP BY clause.
>
> If I delete the last line, the query is Ok :
> select  'Voie'=NVOI,'Mois'=datepart(mm,DPSTVOI)
> ,'Année'=datepart(yy,DPSTVOI),'Période'=CPST,'Nombre'=count(NVOI)
> from HREH3M
> group by CPST,NVOI,datepart(yy,DPSTVOI),datepart(mm,DPSTVOI)
> order by CPST,NVOI,datepart(yy,DPSTVOI),datepart(mm,DPSTVOI)
>
> The problem is with COMPUTE claude, but I can't understand why.
>
> please help me to solve this.
>
> thanks in advance
>
> regards
>
>     Laurent
>
>
>

> What kind of error or warning appears when you drop that line? Apparently
> syntax for COMPUTE is fine.
>
> "Laurent CLAUDEL" wrote:
>
>> Hi,
>>
>> I have this query ( it is Ok with Sybase SQLServer)
>>
>> select  'Voie'=NVOI,'Mois'=datepart(mm,DPSTVOI)
>> ,'Année'=datepart(yy,DPSTVOI),'Période'=CPST,'Nombre'=count(NVOI)
>> from HREH3M
>> group by CPST,NVOI,datepart(yy,DPSTVOI),datepart(mm,DPSTVOI)
>> order by CPST,NVOI,datepart(yy,DPSTVOI),datepart(mm,DPSTVOI)
>> compute sum(count(NVOI)) by CPST,NVOI,datepart(yy,DPSTVOI)
>>
>>
>> I want to migrate it under MS SQLServer 2000, but I have this error
>> message
>> :
>> Serveur : Msg 8120, Niveau 16, État 1, Ligne 1
>> Column 'HREH3M.DPSTVOI' is invalid in the select list because it is not
>> contained in either an aggregate function or the GROUP BY clause.
>>
>> If I delete the last line, the query is Ok :
>> select  'Voie'=NVOI,'Mois'=datepart(mm,DPSTVOI)
>> ,'Année'=datepart(yy,DPSTVOI),'Période'=CPST,'Nombre'=count(NVOI)
>> from HREH3M
>> group by CPST,NVOI,datepart(yy,DPSTVOI),datepart(mm,DPSTVOI)
>> order by CPST,NVOI,datepart(yy,DPSTVOI),datepart(mm,DPSTVOI)
>>
>> The problem is with COMPUTE claude, but I can't understand why.
>>
>> please help me to solve this.
>>
>> thanks in advance
>>
>> regards
>>
>>     Laurent
>>
>>
>>

> if I drop the last line (COMPUTE), there is no more error.
>
> "Enric" <En***@discussions.microsoft.com> a écrit dans le message de news:
> B27D7A22-9880-4A31-9335-D0C77C2DE***@microsoft.com...
>> What kind of error or warning appears when you drop that line? Apparently
>> syntax for COMPUTE is fine.
>>
>> "Laurent CLAUDEL" wrote:
>>
>>> Hi,
>>>
>>> I have this query ( it is Ok with Sybase SQLServer)
>>>
>>> select  'Voie'=NVOI,'Mois'=datepart(mm,DPSTVOI)
>>> ,'Année'=datepart(yy,DPSTVOI),'Période'=CPST,'Nombre'=count(NVOI)
>>> from HREH3M
>>> group by CPST,NVOI,datepart(yy,DPSTVOI),datepart(mm,DPSTVOI)
>>> order by CPST,NVOI,datepart(yy,DPSTVOI),datepart(mm,DPSTVOI)
>>> compute sum(count(NVOI)) by CPST,NVOI,datepart(yy,DPSTVOI)
>>>
>>>
>>> I want to migrate it under MS SQLServer 2000, but I have this error
>>> message
>>> :
>>> Serveur : Msg 8120, Niveau 16, État 1, Ligne 1
>>> Column 'HREH3M.DPSTVOI' is invalid in the select list because it is not
>>> contained in either an aggregate function or the GROUP BY clause.
>>>
>>> If I delete the last line, the query is Ok :
>>> select  'Voie'=NVOI,'Mois'=datepart(mm,DPSTVOI)
>>> ,'Année'=datepart(yy,DPSTVOI),'Période'=CPST,'Nombre'=count(NVOI)
>>> from HREH3M
>>> group by CPST,NVOI,datepart(yy,DPSTVOI),datepart(mm,DPSTVOI)
>>> order by CPST,NVOI,datepart(yy,DPSTVOI),datepart(mm,DPSTVOI)
>>>
>>> The problem is with COMPUTE claude, but I can't understand why.
>>>
>>> please help me to solve this.
>>>
>>> thanks in advance
>>>
>>> regards
>>>
>>>     Laurent
>>>
>>>
>>>
>
>