SQLSACT (7/16/2012)

---

Lynn Pettis (7/15/2012)

---

The following code provides you with a cursor, while loop, and a set-based solution. Depending on the level of control you need will determine which you...

What tool are you using, SSMS or BIDS?

The following code provides you with a cursor, while loop, and a set-based solution. Depending on the level of control you need will determine which you use.

Also, I changed...

SQLSACT (7/15/2012)

---

Lynn Pettis (7/14/2012)

---

Not knowing what it is you are doing, using a cursor may be the correct thing to do. They do make sense for maintenance rountines and...

Not knowing what it is you are doing, using a cursor may be the correct thing to do. They do make sense for maintenance rountines and that sort of...

Then the query I gave you should show you those records in the first table that exist in either table2 or table3.

Okay, let's try again. You want to delete records from table1 if the same record exists in either table2 or table3, correct?

SQL_Loser (7/13/2012)

---

I have performed the following query for someone to eliminate records in a table if they exist in either of two separate tables. I thought it was...

gerard-593414 (7/13/2012)

---

Hi Lynn

Sorry, but I'm not answering any questions until mine have been answered.

Why the SELECT/UPDATE structure?

What is it giving you?

This is my first post in this forum, working around...

Logshipping is available in standard edition. You could use logshipping to keep a current version of the production database (including schema changes moved to production) in Dev and/or QA....

Are you volunteering to do this and...

gerard-593414 (7/12/2012)

---

Hi Lynn. Thanks for that.

Just 2 questions:

1. Instead of using the two locks, can I use an IsolationLevel instead. I am not sure if the framework I am using...

Yes, saw that on twitter yesterday.

Some people will never learn I guess.

Shot in the dark here since you haven't really provided enough information regarding the environment to make a better answer.

I am assuming that the principal server will still be accessible...

CELKO (7/13/2012)

---

>> I have 2 tables with the following structure.<<

Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc....