Posted by Matik on 12/04/05 22:09

Gert-Jan!

Thanks. This might be that. I'll review the coding keeping that in my
mind. This could be an issue, because, as far I can remember, joins
are done in different order.
Am I right that You mean referencing them in the same order by JOINS?
Not generaly in the sp code?

I'll check booth possibilities tommorow (also removing index).

Thanks,

Mateusz

• Next in forum: Re: 1 SP with dynamic input parameters and multiple rows as the source of the query
• Prev in forum: Re: 1 SP with dynamic input parameters and multiple rows as the source of the query
• Thread view: Re: Help needed by deadlock problem

[Reply to this message]