RE: Cross tab
David,Let me explain my problem hereCREATE 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 […]
2004-04-07