I have a table in that two fields stores the value of time stamp for eg 2009-12-10-20.00.26.424000 - DQ1CREATED 2009-12-10-20.00.26.860000-DQ2CREATED these two fields should be compared such that if there is a diff of 5 mins i need to get an alert as well as if any one of the field is blank i need to get an alert.
This i need to implement in a job. Any suitable query for this ?
Thanks a lot in advance
December 17, 2009 4:42 AM
January 6, 2010 5:00 AM