Hi Lester and thanks for the reply.

I go back to work on Monday and so I wont be able to test this until then, but I really appreciate it, as...

yep... below is what i get:

(3 row(s) affected)

(3 row(s) affected)

KeyID

--------------------

22222.001.01

(1 row(s) affected)

the tricky part (for me) is if the id (in table A) exist at any level in table B then it should NOT print.

TABLE A ...

hello.. ok, i jsut found out a catch I was not aware of.

if in tableA the id exist and looks like 22222.222.22.01.01 and in tableB the base (which is...

Hello, I am sorry for the confusion.

Basically the script will run every night, it will look at the end_dates of the second level ie.

Project ...

gotcha... thanks for your help!!!

hey that worked... thanks so much for your help....

let me ask one more question if that is ok....

same scenario, but say the lower levels have a description but the upper...

I am so sorry to keep bugging you with my lack of knowledge...

is there supposed to be something by the 😉 below?

is there a forum for 2000?

oops...

Is there any help you can provide me with this or do I have to repost?

I sm on SQL Server 8.0.2039

hey Lynn, thanks... for some reason it gives me an error on the "with"...

Msg 156, Level 15, State 1, Line 16

Incorrect syntax near the keyword 'with'

I am not sure why?

hey thanks for the quick reply.

that sounds good, although I do not ahve access to change or add anything to the tables.

this is an existing table that is and has...

Hello Bob, I am stuck again... I posted the below and wondered if you had any solution...

I have the below data in a table called say "kipp".

I am trying to...

hey there... tahnsk for your help... I posted the result as I was getting an error... Sure it is something silly, I just cant figure it out. Would you mind...