SELECT type,stathour, sum(counter) AS qty, Year(statDate) AS reportYear, Month(statDate) AS reportMonth, Max(statDate) AS LastEntered, Min(statDate) AS FirstEntered FROM tadstats WHERE placementid= and statdate >=#createodbcdatetime(createdatetime(year(start),month(start),day(start),0,0,0))# and statDate <= #createodbcdatetime(createdatetime(year(stop),month(stop),day(stop),23,59,9))# and ((Type)='Impression') GROUP BY Year(statdate), Month(statdate), Type, stathour ORDER BY Year(statdate) , Month(statdate), stathour; SELECT type,stathour,sum(counter) AS qty, Year(statdate) AS reportYear, Month(statdate) AS reportMonth, Max(statdate) AS LastEntered, Max(statdate) AS FirstEntered FROM tadstats WHERE placementid= and statdate >=#createodbcdatetime(createdatetime(year(start),month(start),day(start),0,0,0))# and statDate <= #createodbcdatetime(createdatetime(year(stop),month(stop),day(stop),23,59,9))# and ((Type)='click') GROUP BY Year(statdate), Month(statdate), Type,stathour ORDER BY Year(statdate) , Month(statdate), stathour; select sum(qty) as total from request.rsdataImps select sum(qty) as total from request.rsdataClicks insert into tadstats (type,placementID,stathour,statdate,counter) values( , , #stathour#, #createODBCDatetime(statDate)#, 1) update tadplacements set billable=billable+#arguments.rate# where placementID = select placementid,type,statdate,stathour,sum(counter) as Total from tadstats where date=#createodbcdate(arguments.thedate)# group by placementid,type,statdate,stathour delete from tadstats where date=#createodbcdate(arguments.thedate)# insert into tadstats (type,placementID,stathour,statdate,counter) values( '#rs.type#', '#rs.placementID#', #rs.stathour#, #createodbcdate(arguments.thedate)#, #rs.total#) select ip from rsWhiteList where ip= delete from tadipwhitelist where siteid= //now make Macintosh style into Unix style insert into tadipwhitelist (ip,siteid) values (,)