grtn316 (4/3/2008)

---

Ok, I went into my database diagrams and updated a few table relationships and it seems to have fixed the delay. However, they still do not say "Seek" instead...

I'd convert the query as follows:

Change the "Not In" part to a left outer join and get rid of the string functions in it.

Change the "In" part to an "exists"...

Sounds like a job for a set of complex, custom scripts.

In Management Studio (I assume you're using that since this is the SQL 2005 forum; if it's actually Query Analyzer, it works the same way), click on the button on...

If it's about the join, it should be...

That particular error usually means there is a duplicate column name in the query. It will parse okay, but will give that error when it runs.

I'm sure you've checked the execution plan on that long-running query. Does it point up any problems on index/table scans, missing statistics, etc?

There's a section in BOL that maps the various 2k system tables to 2k5 system views.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a616fce9-b4c1-49da-87a7-9d6f74911d8f.htm

I've found it very useful.

Lynn Pettis (4/3/2008)[/b

Okay, fine. Let's add one more criteria to the mix, in the table definition ID is not null. Wait, wait, I have it! Another QOTD...

Of course, to take this to an even more ridiculous level, if ID is the PK (or otherwise not nullable), you don't have to worry about it being null, which...

I think openrowset will do what you need.

Otherwise, a simple SSIS package definitely will. Shouldn't take more than a few minutes to build and test.

Don't feel stupid. The computer version of "and/or" throws a lot of people. Takes a while to get used to.

Do you have to merge data from the two into common tables?

For example, is there a customers table in each database and you have to make it into a single...

What you're looking for is Joins. Look those up in BOL and you'll have a good start on how to solve this.

"What decides which filter to use when there are more than one filters that contradict each other?"

Since you used "and", it uses both filters at the same time on all...