>lcStr = [select weblog.agent, ]+; >[sum(iif(weblog.function="GetCars" or "GETCARS"$weblog.xmlstr,1,0)) as RateRequests,]+; >[sum(iif(weblog.function="CarRes" or "CARRES"$weblog.xmlstr,1,0)) as Bookings ]+; >[from weblog order by weblog.agent group by weblog.agent] >=sqlexec( oConnection, lcStr, "TempCursor" ) >>TIA
[from weblog group by weblog.agent order by weblog.agent]