View Complete Post
Here is an example of my question
I have a column called Department, a column called Employee Name and a column called EmployeeAbsent.
Obviously i can easily use a select satement to get each employee's absent status. However, I would like to generate an additional field called DepartmentAbsent to see if anyone in a particular depart is absent based on the EmployeeAbset field.
how should I write the query?
I have a design problem I could use some help determining how to code this problem.
I have a table with 3 fields, catCode, startDate and endDate. I am having trouble deciding how to query my DB based on the following...
By default a gridview will return all records that match the catCode selected from a dropdown list.
If the user checks a check box, only records are returned where....
startDate <= today AND endDate >= today
How can I apply the If condition to compare when the check box is selected? I used the wizard to build the select statment for the gridview, but I can switch that to a SP if that makes life easier.
Thanks for any and all help and suggestions.