>Hi All
>I have a table Transfer (TransDay D, TranNo I). I want a result cursor containg only four records (each record will be sum(TranNo) for one week) In other words There are 30 or 31 records and i want to group them in to 4 weeks. Any simple way?

SELECT YEAR(TransDay), WEEK(TransDay), SUM(TranNo) ;
  FROM Transfer ;
  GROUP BY 1,2 ;
  INTO CURSOR crsResult