Could you post the DDL (CREATE TABLE statement) for the table, some sample data (INSERT INTO tablename statements) with which to test.

Just one last thing, based on the sample data, what would be the expected output?

This gives us something to test our output against.

NOLOCK will allow the SELECT statements to process regardless of locks help by other processes (a dirty read) but would have no affect on the UPDATE statements.

Actually, I'm wondering why...

Don't know, but as the forum indicates he is still logged on, I hope I didn't scare away this OP.

Just asked for what we always ask for in order to...

Wake up on the wrong side of the bed today (ref: your avatar). 😛

How does the file get created? Is it FTP'ed, or is it being directly created?

jrizzo-1083740 (4/27/2010)

---

who is asking you to write create table scripts? or create sample data? I thought I provided some generic sample data. I need to tweak the query...

The Dixie Flatline (4/27/2010)

---

What Jeff said. The problem is finding the documents out on the web to compare. I've heard that many schools subscribe to...

Do you really expect me to write the create table scripts for your tables and to create sample data for you?

Please provide what has been requested. The more you...

Nope, don't play the game.

Four

If you could post the DDL (CREATE TABLE statement(s)) for the table(s) involved, some sample data (as a series of INSERT INTO tablename statements) for the table(s) involved, the expected...

If you would provide the DDL (CREATE TABLE statements) for the table(s) involved, sample data (series of INSERT INTO tablename statements) that represents the problem you are attempting to solve,...

Sounds like all you may have restored is the production database. Did you setup the logins/users as they were setup on the hosted system? It sounds like things...

Based on the tables and the sample data, what is the expected output? Show us, don't describe it. We need to know precisely what you are expecting so...