I'd write it more like this:

DELETE FROM

dbo.tbItem

FROM

dbo.tbItem I

INNER JOIN dbo.tbProductionOrder PO

...

Sorry to say this, but this doesn't even appear to be a proprerly written query.

select * from test.samp_id,test.b_id,

case when (test.case_active='N' and sample.case_te_date is null)

then 'In Active' when (not tbl_test.case_te_date...

Matt,

Here is a link to Wikipedia that may help jog your memory on thier use:

http://en.wikipedia.org/wiki/Fast_Fourier_transform

Can I personally think of a database application that would use it, not off hand, but...

Big request with no information to work with. For better help fast, read the following article:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

😎

Just so you know; I have found an algorithm that works, and based on my testing, will work no matter the setting of DATEFIRST.

(That is a hint, and goes with...

To paraphrase what someone else once said on this site, "The proof is in the code." Here is the code:

set nocount on;

create table #fun(id int identity(1,1) primary key clustered,...

One query is returning a constant, the other a value from a table.

Where is the simularity between the queries?

Give it up. Neither of us is going to change the...

Not even similiar. Let me know when you decide to give up trying to convince me otherwise.

😎

Now, you should post what you did to complete your process so that others can see it also. You never know, someone else may have a similiar problem that...

VALEK (6/10/2008)

---

The question did not ask you to assign it to 0. The reason the word "consistently" is in the question is because the author of the question realized...

Here is some code to get you started:

create table dbo.backupratetable (

carrier varchar(50),

country varchar(50),

rate decimal(18,4),

effective_date...

That I can't answer, and it looks like to previous thread is still unavailable.

😎

Miguel Pereira (6/10/2008)

---

Mike Levan (6/10/2008)

---

is there a way to split the transactions and execute like ,deleting 5k rows each time. so that it has small log file and can easily...

I don't think either will have a difference if multiple queries were running simultaneously. The best thing to do would be to test both options in a test environment...

GSquared,

Was that the query you took out a join? If so, I seem to remember he did and that it didn't return the results he was expecting. If...