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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-25 : 08:16:36
|
| writes "Vikram writes "Hi,I need some help in date manipulations on SQL server data.I am required to calculate to see 1. If anyone is absent one day within a 30 day period. if they are then upon their next absence in the same rolling 30 day period they need to be move to step I of disciplinary stage.this information has to be checked for hundreds of employees.I tried many ways but am not getting the right results. Moreover upon defaulting they will have to be moved to differnt steps.Any suggestions will be greatly appreciated.thanks in advanceVik"" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-25 : 08:39:41
|
| Posting DDL, sample and expected result would be helpful to give solutionMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
sql question