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 |
|
h.singh10
Starting Member
16 Posts |
 Posted - 2012-01-18 : 19:28:41
|
| select * from customers where load_tmstp between (select max(end_tmstp) from log) and sysdate.Customer table do have some records where load_tmstp is between max(end_tmstp) and sysdate but i am not getting any records in destination( though the package runs successfully). Database is oracle.max(end_tmstp) LOOKS LIKE THIS : 18-JAN-12 07.18.59.000000000 PMand load_tmstp has value that lies between the above value and the sysdate(current timestamp when i run the job)Any idea why i am getting zero records.Thanks |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-01-30 : 19:32:54
|
| please show us values of select max(end_tmstp) from log and sysdatedo they both contain datetime? and are the values what you are looking for?If you don't have the passion to help people, you have no passion |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-30 : 19:37:17
|
| is end_tmstp field of date type? did you check in oracle query editor and see if query is giving correct results?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Oledb Query (date range)