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

Shailesh Chaudhary (11/17/2008)

---

I have two Tables

Citation(CitationID, Date , ISReportTaken) and ReportExport(CitationID, ApplicationID, ISExported)

I want to insert One column records from Citation table to reportExport with ApplicationID =2 and ISExported =1...

Run this query and see what you find:

select * from msdb.dbo.backupset where database_name = 'DBSwsam' -- use the appropriate DBName here

I also reread your orinial post, and have a change.

Select all records with an end date of yesterday:

select

*

from

dbo.myTable

where

EndDt...

Looks like you are trying to backup to a mapped drive. That may be the problem. Can you change the destination of the backup file to use a...