Glad you liked it. Hope you read ther other article, to which was referred in this article as well. Same functionality, different approach.

Tnx for answering. Found a very worthwhile article here. I have used this to create the functionality I needed.

Tnx again.

Got it, tnx. Amazing, that I am not SA while I am Windows Administrator... Also amazing, that I can change my permission WITHOUT being SA...

Weird set-up procedure, I guess.

Tnx Michael,

But it would still mean I need your whole previous script. I'll solve it another way by creating a large base sequence-length and building the statement. Consequence is...

Hi Michael,

It works fine, noproblem, even with 'real' data I have used. However, this will be difficult to implement, since the apl has to connect to both SQL Server and...

No other suggestions?

Obviously, for any two jobs this needs to be expressed only once. Thus all entries in your job pair table must be unique. Is this true?

Thus you want to manage...

Michael,

I think you summed it up pretty well. Your "UNION" script gives me the data in the format I need/want, the client just has to fill a Flexgrid with the...

It seems to me that this should be written by the application's procedural language. It's not ideal for SQL.

But... I have read up a lot on recursive querying and hierarchical...

Tnx for answering Matt.

However, at first sight thye code does not work: all records end up with NULL as seqnum and 0 as seqdepth. I'll have a look at the...

Matt,

You are correct, but this is easily checked when creating a sequence. No sequences currently exists and won't be when this apl goes live. Sequences have to be made by...

Yet another question on this: storing sequence infortmation is not an option. Is there an easy way to find the longest existing sequence before creating the query Michael has provided?...

When a a chain from a sequence is removed 2 new sequences appear.

Cl_01=>Cl_02=>Cl_03

If the middle chain Cl_02 is removed 2 the new sequences are Cl_01 and Cl_03. Ofcourse, single-sequences...

Hi Michael,

I've done some testing and sofar your code seems to be the thing I need. Thanks a lot!

Hi Michael,

I'll have a look at your code tomorrow, it looks good. The max length would be not more then 10, but that's a user talking...

Tnx for the help sofar.