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