Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ReLski
Starting Member
5 Posts |
 Posted - 2011-01-13 : 08:54:29
|
| EmployeeID|LeaveFrom|LeaveTo 0056 |8/9/2010 |8/15/2010 | |I want get the range of this fields that will be something like this:8/9/20108/10/20108/11/20108/12/20108/13/20108/14/20108/15/2010and then compare this list of dates to column 'LogDate' of this tableEmployeeID|LogDate | 0056 |8/9/2010 | 0056 |8/10/2010|if the list of dates is equal to 'LogDate' thenSet @TotalDeduction = 0 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Stored Procedure please Help