That's right. But employee name etc is in employee table and the leave data is stored in a seperate table. Each day of leave in that table is one record. So i need recordcount for each leavetype for that employee. Hope that answers your question. Any clues?
On Sat, 25 Dec 2004 21:38:30 -0600, Jared Rypka-Hauer - CMG, LLC <[EMAIL PROTECTED]> wrote: > Ken, > > Just to clarify, you're trying to get summary data on leave items, > right? Like this: > > Joe: Vacation: 10 | Sick: 15 > > With a date range and stuff too, but that's the basics, right? > > J > > > On Sat, 25 Dec 2004 22:19:18 -0500, Ken <[EMAIL PROTECTED]> wrote: > > Thanks Jared. I am simply looping through the records using <cfoutput > > query="abc"> > > > > Also, i just tried your select statement and i am still getting the > > exact same recordset. Here's what I am doing now: > > > > SELECT FirstName, LastName, Email, LeaveLogID, EmployeeID, Leavetype > > FROM employee LEFT OUTER JOIN SASCalendar ON > > employee.EmpID = SASCalendar.EmployeeID > > where ApproverID=10005 AND (YearMonth like '%12' and YearMonth like '2004%') > > order by employeeID, yearMonth, leaveType > > > > Any ideas? should i be using Q of Q? If so, please guide. > > > > Thanks, > > Ken > > > > On Sat, 25 Dec 2004 20:22:26 -0600, Jared Rypka-Hauer - CMG, LLC > > <[EMAIL PROTECTED]> wrote: > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188791 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
