Not talking about you, at least this time.

Some people really shouldn't be allowed near SQL Server systems.

jitendra.padhiyar (4/3/2012)

---

Service pack of My current sql server 2000 is SP2 so to upgrade it to SQL2K8 it is must upgraded to SP4. I downloaded "SQL2000-KB884525-SP4-ENU.exe" to upgrade service pack...

Based on your sample data above, what is the expected results you are looking for from the query?

You would get better answers to your question if you posted more information. To be precise, you should post the DDL (CREATE TABLE statement(s)) for the table(s), sample data...

shermola1 (4/3/2012)

---

Thanks again for the suggestions! Sean, I didn't do Insert statements because I wanted to give a larger dataset than I was willing to type out manually and...

Welsh Corgi (4/3/2012)

---

It appears that the person of interest has no intention of ever clearing the Staging. :hehe:

They will retain the Initial Load and each incremental load.

THe staging is...

Start here: http://msdn.microsoft.com/en-us/library/ms176034.aspx

Looks like it is doing just what you need. It is doing an index seek on the primary key.

What do you think is wrong with the query?

From Books Online:

Limitations of Page Restores

--------------------------------------------------------------------------------

Only database pages can be restored. Page restore cannot be used to restore the following:

Transaction log

Allocation pages: Global Allocation Map (GAM) pages, Shared...

I think you have been around long enough to know that what we need is the DDL for the tables (CREATE TABLE statements), sample data (INSERT INTO statements) for the...

Steve Cullen (4/3/2012)

---

I don't understand what you're trying to do. Your DDL is incorrect, but I assumed you are trying to create a table. I don't see a...

Best thing you could do, test this in a test environment to be sure it does what you expect. If both files are in the same file group I...

The problem you are facing is that you are calculating the number of vendors that are 2,5,10, and 20 miles away from each zipcode in the Location table. At...

You can tell SQL Server where to palce the new file using RESTORE LOG using the WITH MOVE clause. You would have to handle the restore of the log...