Posted by Erland Sommarskog on 02/06/07 10:24

Wes Groleau (groleau+news@freeshell.org) writes:
> Erland Sommarskog wrote:
>> And if only the timeout bothers you, run the UPDATE from QA. QA does not
>> have any timeouts.
>
> Surprise! I went back to QA with your JOIN method. It would not accept
> it, nor various modifications of it.

Well, since you never care about posting your table defitions or sample
data, do you really expect me to post a tested working query? Maybe you
could at least post the actual query you tried, and the error message?

I am sorry if my tone is somewhat irritated, but it is very difficult
to assist when the person asking for help refuse to dislose vital
information.

> The one that ended
> WHERE X.Seg_Nbr BETWEEN Inv_Data.CLP_Seg AND Inv_Data.CAS_Seg
> got a timeout from the server after about a minute.
> (So perhaps QA doesn't timeout, but the server still does!)

Again, can you post the actual error message, and the exact query you are
using? If you get a timeout, it may be that you are using a linked server.
(Not that you ever said that you are using linked server, but at this
point I'm starting to feel like a participant in a quiz competition.)


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]