>I have a table which lists document revisions. We have two types of revisions, DCN(Drawing Change Notice) and EO(Engineering Order). My table is set up to record revision date(Field 1) and type of change code(1 or 2)(Field 2). I need to know how many DCN's were completed on a certian month and like wise EO's for that month.
Something like this:
select revisiontype, count(*);
from MyTable;
where date between ldStartDate and ldEndDate;
group by RevisionType
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)