David,
Let me explain my problem here
CREATE TABLE TEMP
(ID INT,
stdate DATETIME,
CODE CHAR(10))
INSERT INTO TEMP VALUES(1,'2004-04-01','TEST1')
INSERT INTO TEMP VALUES(2,'2004-04-02','TEST1')
INSERT INTO TEMP VALUES(3,'2004-04-03','TEST1')
INSERT INTO TEMP VALUES(4,'2004-04-01','TEST2')
INSERT INTO TEMP VALUES(5,'2004-04-02','TEST2')
INSERT INTO TEMP VALUES(6,'2004-04-03','TEST2')
INSERT INTO TEMP VALUES(7,'2004-04-01','TEST3')
INSERT INTO TEMP VALUES(8,'2004-04-02','TEST3')
INSERT INTO TEMP VALUES(9,'2004-04-03','TEST3')
INSERT INTO TEMP VALUES(10,'2004-04-01','TEST4')
INSERT INTO TEMP VALUES(11,'2004-04-02','TEST4')
INSERT INTO TEMP VALUES(12,'2004-04-03','TEST4')
INSERT INTO TEMP VALUES(13,'2004-04-04','TEST4')
INSERT INTO TEMP VALUES(14,'2004-04-05','TEST1')
INSERT INTO TEMP VALUES(15,'2004-04-06','TEST1')
INSERT INTO TEMP VALUES(16,'2004-04-06','TEST2')
INSERT INTO TEMP VALUES(17,'2004-04-01','TEST1')
If user asks report stdate between 2004-04-01 and 2004-04-06,means he wants to ignore the week end.
CODE 2004-04-01 2004-04-02 2004-04-05 2004-04-06 TOTAL
------------------------------------------------------------------------------
TEST1 2 1 1 1 5
TEST2 1 1 0 1 3
TEST3 1 1 0 0 2
TEST4 1 1 0 0 2
TOTAL 5 4 1 2 12