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...

Also, after reviewing your post a second time. We could also use the DDL to recreate your current indexing scheme on the three tables.

😎

You are part way there. Yes, you posted the DDL for the tables. Yes, you posted some data. Unfortunately, the data is not posted in a format...

Matt,

As to your second question. The "alias by assignment" notation (your first option) is actually deprecated and will no longer be supported in a future version of SQL Server...

It could also indicate the possibility of successful SQL Injection attacks.

😎

This was a very good question. I definitely learned something new from this one.

😎

And please agree -- RDB is an exact science, at least in its principle, I've seen many dodgy code in my life, and also many TSQL pieces relying on hardcoded...

The DDL to create the tables, some sample data (in the form of insert statements) to populate the tables, and the expected output from the query based on the provided...

Sorry, I can't agree with you.

One, I understood the question and what it was asking and therefore answered it correctly.

Two, I've been in IT long enough to know...

I think people are making too much of the question. The real point of it wasn't the data used in the question but the BETWEEN clause itself. The...