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 |
|
F1nd1nfo
Starting Member
4 Posts |
 Posted - 2009-05-02 : 10:25:58
|
| Package_Start_Dte Package_End_Dte Package_Exit_Error Process_Status----------------------- ----------------------- --------- ----------------------------------- 2007-12-03 18:22:31.910 2007-12-03 18:23:30.597 0 [Move] Successfull. Keys Moved: 28352007-12-03 18:17:31.867 2007-12-03 18:18:17.397 0 [Move] Successfull. Keys Moved: 27242007-12-03 18:12:32.010 2007-12-03 18:13:20.103 0 [Move] Successfull. Keys Moved: 29992007-12-03 18:07:32.310 2007-12-03 18:08:31.140 0 [Move] Successfull. Keys Moved: 30822007-12-03 18:02:31.940 2007-12-03 18:03:33.533 0 [Move] Successfull. Keys Moved: 29312007-12-03 17:57:32.553 2007-12-03 17:58:37.333 0 [Move] Successfull. Keys Moved: 35142007-12-03 17:52:33.150 2007-12-03 17:53:16.917 0 [Move] Successfull. Keys Moved: 30102007-12-03 17:47:32.470 2007-12-03 17:48:14.357 0 [Move] Successfull. Keys Moved: 2883Hi Need Assistance please. I'm fairly new at this and require sql statement for the Amount of keys processed for every hourbetween the Package_Start_Dte and Package_End_Dte. Your assistance much appreciated. Also, the average amount of keys in an hour as well as the keys processed for the day. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
Need some assistance