Search results

  1. W

    Adding/Subtracting across adjacent table rows

    Is it possible to perform calculations across 2 adjacent rows in SQL? At the moment, I have a running count that tracks the number of updates that go into our database against a specific JobID. Is it possible to subtract the running count for a previous update from the current update. For...
  2. W

    Adding/Subtracting from previous/next row

    Is it possible to perform calculations across 2 adjacent rows in SQL? At the moment, I have a running count that tracks the number of updates that go into our database against a specific JobID. Is it possible to subtract the running count for a previous update from the current update. For...
  3. W

    SQL to get a job start time and end time??

    Hi, I have a database that tracks jobs as they are being completed. I have 2 tables, the first of which contains details of the jobs and the second contains details of the individual tasks that make up each job (Job and Task respectively) Within the Job table, there are several fields...
Back
Top Bottom