>>Hi,
>>
>>The SQL Select I have that works with VFP does not work with SQL Server database. The SQL statement has HAVING clause. For example (simplified) the following does not work with SQL Server database:
>>
>>

>>select COUND(DISTINCT(WO_NUMBER)) AS TOT_NUM from MyTable WHERE <SomeCondition> HAVING TOT_NUM > 5
>>

>>
>>The error is Invalid Column name TOT_NUM. How would I change the above SQL Select make the HAVING working?
>>TIA.
>
>

>select COUNT(DISTINCT WO_NUMBER) AS TOT_NUM
>       from MyTable
>WHERE <SomeCondition>
>HAVING COUNT(DISTINCT WO_NUMBER) > 5
>

Actually I just tried your and Dragan suggestion and with the GROUP BY it works. The code:

>

>select ID_FIELD, COUNT(DISTINCT WO_NUMBER) AS TOT_NUM
>       from MyTable
>WHERE <SomeCondition> GROUP BY ID_FIELD
>HAVING COUNT(DISTINCT WO_NUMBER) > 5
>

And the resulting query I get is what I am looking for. So it works.

But my questions are
1. Doesn't the above code make the COUNT to be executed twice (thus increasing the time of the execution)
2. Why in case of VFP using the calculated name (AS) works? Does it mean that with VFP data the execution time would be better?

Thank you.