Hi,
I am trying to get some records using a SELECT statement. In the table structure I have 6 columns. Below is my table structure,
1. Employee ID INT
2. RequestedFrom DATETIME
3. RequestedTo DATETIME
4. ApprovedFrom DATETIME
5. ApprovedTo DATETIME
6. NoOfDays INT
What I want to do is select all records from the table WHERE the [ApprovedFrom] BETWEEN @StartDate AND @EndDate, AND IF ApprovedFrom IS NULL THEN Instead of [ApprovedFrom], it must check the [RequestedFrom].
Thanks
View Complete Post