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 - 2001-07-26 : 09:46:12
|
| Jaydeep writes "I am creating employees gate pass system i want to check number of the checkin and checkout by employee per day. i have a database for each entry and exit for each employee .. There is a rule which i have to enforce in the system that if the employee check's out and is back within 10 minutes then this checkin and checkout should not be accounted for counting the movements of the employees. I am using DTS for the same thing . In DDQ I have taken one global variable for storing previous check out time and comparing to the current check in time. if the time difference is less than 10 minutes then i am skipping the row other wise it is transfered to the Table . But it is executing statements after return statement.eg. Main=DTSTransformStat_SkipRow MsgBox "ended"In my case it should not show the msgbox but some how it is showing it . and giving weird results.So if u could suggest what should i do in order to solve this problemthanking you" |
|
|
|
|
|
Data Driven Query