delete from

dbo.MainTable

from

dbo.MainTable mt

inner join dbo.DeleteTable dt -- table of primary keys to be deleted

...

You only need the REPLACE option on the RESTORE if the .mdf/.ldf files already exist on the server you are restoring the database.

Going in a different direction, away from your queries, to indexes. How are you indexing your tables? Will you have a primary key on each table? Will...

I would agree when the Developer Edition of SQL Server was more expensive. With the Developer Edition only costing $50.oo, and it can be used in the development, test,...

To do what you are trying, you first have to define (create) the temporary table with the columns defined with the appropriate data types that will be returned, then you...

I would make the following simple change since you didn't say what is wrong with your existing query.

SELECT

c.CustomerID,

...

You don't need the database files to restore a database from the backup files. This why you can restore the database to a brand new server, it will create...

Could you post the create statements for both tables, sample data for both tables, the expected results after the query (the insert inthis case) is run, and the code you...

Lynn Pettis (11/17/2008)

---

Assumptions:

1) Using SQL Server 2005 (this is a SQL Server 2005 forum)

2) Database is using the Full Rocovery Model

3) All records to be deleted are based on the...

Assumptions:

1) Using SQL Server 2005 (this is a SQL Server 2005 forum)

2) Database is using the Full Rocovery Model

3) All records to be deleted are based on the following original...

mpdillon (11/17/2008)

---

Lynn,

Thanks for your replies. You have started me thinking in different direction than I had been. The problem I am trying to solve is one of comparing dates but...

Could be caused by network issues or your server has gone down, or simply was rebooted (this is usually what happens to me here at work over night).

I'm flattered that you waited. I'll be honest, I don't always look to see who may be reading any given thread.

I also guess that we tend to think a...

Look at the Type. Full backups are D differentials are I and T-Logs are L. You want to ensure that your are restoring the lastest full backup. ...

Garadin (11/17/2008)

---

If you only want citations with a date > 11/12/05 that don't exist in the table, add

AND C.Date > '11/12/2005'

to the end of Lynn's query.

Also, for future...