>CREATE CURSOR crsTest (ID C(10), Week I, Hrs N(10,2)) >INSERT INTO crsTest VALUES ([ID1], 1, 12) >INSERT INTO crsTest VALUES ([ID1], 1, 12) >INSERT INTO crsTest VALUES ([ID1], 1, 12) >INSERT INTO crsTest VALUES ([ID1], 1, 12) >INSERT INTO crsTest VALUES ([ID1], 1, 12) >INSERT INTO crsTest VALUES ([ID1], 1, 12) >INSERT INTO crsTest VALUES ([ID1], 1, 12) >INSERT INTO crsTest VALUES ([ID1], 1, 12) > >INSERT INTO crsTest VALUES ([ID1], 2, 12) >INSERT INTO crsTest VALUES ([ID1], 2, 12) >INSERT INTO crsTest VALUES ([ID1], 2, 12) > > >INSERT INTO crsTest VALUES ([ID1], 3, 12) > >INSERT INTO crsTest VALUES ([ID2], 1, 12) >INSERT INTO crsTest VALUES ([ID2], 1, 12) >INSERT INTO crsTest VALUES ([ID2], 1, 12) > >INSERT INTO crsTest VALUES ([ID2], 2, 12) >INSERT INTO crsTest VALUES ([ID2], 2, 12) >INSERT INTO crsTest VALUES ([ID2], 2, 12) > > >INSERT INTO crsTest VALUES ([ID2], 4, 12) >select week, id, sum(hrs) as week_hrs, count(*) as week_cnt from crsTest group by week, id >Borislav,