The only difference between a LEFT JOIN and an INNER JOIN is that there are some NULLs in the right-hand table where there are no matches with the values in...

Perry

I think the problem is that the last line of your ANSI-compliant query effectively turns the join with order_sales into an inner join. You haven't posted any table structure,...

Sentilnathan

It's not really a good idea from a security point of view to use sa for application use. But from a purely technical perspective, you should be able to...

Yes, you do. The account needs to have permissions on the share that you're copying to or from.

John

Does the SQL Server service start under a local account or a domain account?

John

So you're trying to show all books that have been order at least twice? Change books.* in the first line to books.bk_no. That will give you a list...

How efficient is nuclear after you take into account building and decommissioning over the lifetime of the reactor, and extracting the fuel from the uranium ore? And do we...

British Summer Time ended last Sunday (28th October) and so now we're back to GMT. However, the time of this post shows up as BST.

John

It's worse than that. Certain events, such as restoring a database or changing it to or from read-only status, will cause the counters for that database to be removed....

Ah, now that's a different error message. If a column in one of your tables has the IDENTITY property, that means that the value in that column is automatically...

It's just an alias for the derived table. You could also use S, T, CatsAndDogs or (almost) anything you choose.

John

Gary

I don't think those parentheses are valid syntax, although that doesn't explain the specific error that you got. Have you checked which user owns the table ACHBatches in the...

Nicholas Cain (10/30/2007)

---

I do not believe that the answer is correct.

The question was the fastest way to delete every row in a table.

Delete and truncate are not the same thing.

Should...

Surely "American capitalism at its finest" would see the tickets priced at a level such that the number of people willing to pay for them is equal to the number...

Russ

I'm not clear exactly what you're trying to do - what is the T-SQL that you're running? It may also help if you give us the table and SP...