[thelist] SQL Statement problem

[Howard Cheng]

I know in MS SQL Server you can't group by an alias. In this case, your
only solution is to use the same function in your GROUP BY clause.

In other words,

SELECT
         COALESCE(...)
FROM ...
GROUP BY
         COALESCE(...)

At 03:26 PM 2/11/2002 -0600, Seth Bienek wrote:
>SELECT
>         COALESCE (DATEPART(ww, approved_date), DATEPART(ww,
> terminate_date)) AS
>status_date,
>         COUNT(approved_date) AS apdate,
>       COUNT(terminate_date) AS tdate
>FROM
>         applications
>WHERE
>         company_key = 'LI'
>         AND
>         (approved_date BETWEEN '01/01/2001' AND '01/01/2002')
>         OR
>         (terminate_date BETWEEN '01/01/2001' AND '01/01/2002') AND
> (terminate_type =
>'declined')
>GROUP BY
>         status_date

::::::::::::::::::::::
Howard Cheng
howcheng at ix.netcom.com
AIM: bennyphoebe
ICQ: 47319315