>>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.
>
>In SQL Server it should be
>
>select COUNT(DISTINCT(WO_NUMBER)) AS TOT_NUM from MyTable WHERE <SomeCondition> HAVING COUNT(DISTINCT(WO_NUMBER)) > 5
>
>If you want the same code to be used in both VFP and SQL Server you can do
>
>select * from (select COUNT(DISTINCT(WO_NUMBER)) AS TOT_NUM from MyTable WHERE <SomeCondition>) X
>WHERE TOT_Num > 5
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham