Search results for query: *

The correlated subquery worked! Thank you ESquared and others for your responses and help!! I really appreciate it. Shane

Here is some sample data: Table 1 - Error Table ID EventDateTime ReelStand Speed 1511 2007-08-15 02:22:56.000 1 60000 1512 2007-08-15 03:32:06.000 3 30000 1513 2007-08-15 12:17:32.000 4 45000 1513 2007-08-15 12:35:32.000 3 22000 Table 2 - Paper Consumption Table ID...

I am trying to Join data from two different tables where there is not a direct link. I need the first entry from Table 2 that occurs after the entry in table 1 where an equipment ID matches. The data sources are from 2 systems that are not directly linked and Table 2 is only populated upon...

Are the tape drives the exact same model? If not and you are using hardware compression, they may not be able to read the others tapes.

What type of connectivity do you have between your sites? If you ping between two of the other locations do you get the same results. In my experience a drop rate of 1 in 20 indicates a significant problem somewhere. Possibly a bad T-1 line, a congested Internet connection,a bad network card...