Can you normalise that system?

Can you post more details about the data you can access and the data you need to extract?

Who are the wolves?

There are always negative number .

It's probabely another table that needs to access this data with an opened transaction... Since no table can release the lock, it deadlocks...

can you run this next time??

exec sp_who2

find the...

Your life as a Journeyman on ssc.com... will become veteran or something.

If that doesn't work... can we see the code you're using the populate the variable (with the necessary info to reproduce the behavior)?

Why should they tell you how to code the app?

How long does it take to run the report with a join?

You should not denormalize the db because someone in management...

I'll be over by then end of the day at your current post speed.

I still want more details... I never worked with those kind of systems.

Maybe but you still got the message .

Do you have other exemples?

Hmm, you'd have to write a recursive sp to delete the absolete items (assuming you have no pre-defined limit to the recursive level). I think it would be simpler...

I hate to have to do this, again :

73,32,97,103,114,101,101

.

It only needs to be opened at the moment you open the report... once the query is passed on the server you can close the other form.

You had it easy on this one... I'm just monitoring it .