My suggestion is not a happy one. Basically because I seem to have run into this uncertainty of dealing with multiple splits. In any case, have a go at this...

Hans,

Let's go back to square 1.

So the essential entity being managed is the job pair table where each row contains two jobs where one must occur before the other. Obviously,...

Matt, yes you did essentially implement what I wrote with the exception of the 'sequence split'. What Hans needs to tell us if the 'vetical' orientation of the generated output...

Matt, I think your approach doesn't get the right answer. It interprets 1-2-8 and 1-2-4-5-6 as one sequence.

Hans, to find any solution at all, let's describe a procedural algorithm for...

Great.

But 10 levels is going to be a lot.

I have also wondered how this table is managed - especially in regards to deleting 'things' from that table. Deleting one sequence...

createdate is never updated - otherwise it would lose its meaning.

sp_grantdbaccess will generate an error if the user already exists.

As I said, you need to go through a sp_revokedbaccess/sp_grantdbaccess sequence....

As I said, this approach is valid only if the length of a sequence is within a reasonable limit and the number of rows in the table is reasonable. You...

You have decided to switch to NextCluster instead of PrevCluster. I prefer NextCluster because I tend to read from left to right .

Doing a...

Indeed, All gives you Successes and Failures.

Should I have said ADO.NET?

You can reference columns by number from within ADO.

Hans, you need to be a bit clearer on this table and what exactly it holds.

Thus if I have job sequences:

job2 - job7

job2 - job1 - job4

job2 - job5 -...

Just the Oracle Client is sufficient.

You can dynamically create and copy a table using

select *

into new_table

from some_other_table

Thus have you tried

select *

into new_table

EXEC MySP

Wandrag,

Is this something new to SS2005?

I know that SS2K can audit into the Windows Application event log either a successful login or a failed login (but not both). And it...