You are right Steve, I don't think this is going to be done in SQL anyways, so it's a moot point now. Still, I wondered if I could refer to...

OK, real data. The table is like this:

CREATE TABLE ClusterAfhankelijkheden(

Cluster  varchar(10)

NextCluster Varchar(10)

)

Data:

Cluster        NextCluster

Cluster_01        Cluster_02

Cluster_02        Cluster_04

Cluster_02        Cluster_08

Cluster_03        Cluster_04

Cluster_04        Cluster_05

Cluster_05        Cluster_06

Cluster_07        Cluster_08

A value in column...

Maybe the OP can shed some light on where the data for this table comes from in the real world.

This minimalistic way of storing data enables some piece of code...

Sorry for the delay, did not receive notifications for this thread, cause I had deleted my subscriptions...

On-topic:

I am working on a script, in which I built a tmpTable, for which...

I think I have got it nailed now tnx to a script found here: http://www.lazydba.com/sql/1__12293.html

Now I cannot use the SQL, for the aplication it is used in can connect...

..is that some procs can run in parallel while others have to wait until the previous proc completes. 

This is exactly the case.

I cannot test your example today, will get back...

Ken,

I need yopur help again, I think. Your script runs in SQL2005 and I need to have it run on SQL2K.

Also, I still have no solution for distinguishing between the...

Ken,

Your code seems to do the trick. I'm going to test with real data, but the first few tests look very good. Thanks a lot!

EDIT: Alas, when adding a few...

Imagine this situation:

Job3 needs to start AFTER Job2 has finished AND Job4 has finished. Job2 can start AFTER Job7 has finished. Job7 and Job4 have no preceding job and can...

Ninja,

You are right, a construction like that would make things easier. However, I am not in the position to change the table as it is presented. Also, the table as...

Ah yes, I should have known this!!!

I changed this myself a year ago with similar problem. And now I know some1 changed the maintenanceplans...

But those settings are not in the job?!

This is the jobsteP:

EXECUTE master.dbo.xp_sqlmaint N'-PlanID 5FD22E54-F42A-49B4-BD91-BE0977CD22D5 -Rpt "d:\database\MSSQL\LOG\Maintenance Main0.txt" -DelTxtRpt 2WEEKS -WriteHistory  -RebldIdx 100 '

Right...Never thought of actually trying... I just thought: oh, it's completely seperated, so...

Have to try that! Tnx.

Tnx for all answers. It is really helpful.

Tnx! This is really helpful!