Stored Procedure please Help - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Stored Procedure please Help

Author

Topic

ReLski
Starting Member

5 Posts

Posted - 2011-01-13 : 08:52:53

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/2010
8/10/2010
8/11/2010
8/12/2010
8/13/2010
8/14/2010
8/15/2010

and then compare this list of dates to column 'LogDate' of this table
EmployeeID|LogDate |
0056 |8/9/2010 |
0056 |8/10/2010|

if the list of dates is equal to 'LogDate' then
Set @TotalDeduction = 0

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-01-13 : 08:58:34

Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=155205

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources