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

You'd be really amazed what could be done if you provided the DDL of the tables, sample data, expected results based on the sample data. The more information provided,...

-- Yes; but only in THIS PARTICULAR CASE.

And how to rename ....is it the same as right click the...

If the database is using the Full RecoverY model, you need to run a transaction log backup to remove log records, thereby allowing you to then shrink the transaction log...

First problem with your query is mixing join styles. You use the ANSI Standard for the LEFT OUTER JOIN, but keep the old style join for your INNER JOIN....