couldn't you do a sub select there like (Select count(distinct fc) >From table Where date = '1/31/2004') as dailyamount
Adam H On Tue, 01 Feb 2005 07:24:54 -0400, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Sark, Ron wrote: > > Syntax to be translated - where IF(datea >=datec), use datec, else use > > datea (see bold conditions on line 4) > > CASE WHEN datea >= datec THEN datec ELSE datea END > > > > 2 Count(distinct case when datea = '01/31/2005' then a.fc else null > > end) as dailyamount > > COUNT (DISTINCT ... is not standard SQL, so I can't really help you without > more information on what it is supposed to return. > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2106 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
