I'm working on a timesheet app. This is the record set that's returned from the stored procedure:
Direct_Charge Job CostCode startDate row_Number Col_Number Hours 1 Whatever 001-002 GA 2002-02-01 1 1 8 1 Whomever 001-002 GA 2002-02-01 2 4 1 1 Whatever 001-005 CA 2002-02-01 1 5 3 0 Leave 010-001 LV 2002-02-01 1 2 8 0 Vacation 010-002 VC 2002-02-01 2 11 8 0 Training 006-001 TN 2002-02-01 3 12 8 I need to get the output into something like the following formatting (assuming here that the timesheet starts on the first of the month): Direct Charges: Day of the Month Job CostCode 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Whatever 001-002 GA 8 3 Whomever 001-002 GA 1 Indirect Charges: Day of the Month Job CostCode 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Leave 010-001 LV 8 Vacation 010-002 VC 8 Training 006-001 TN 8 Any suggestions and/or help would be really appreciated. I am tearing my hair out on this one. thanks, larry ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists