Get back to 1 query at a time to add those filters.

Start by selecting the columns before applying the filter.

You can dump the results (copy / paste) into excel and...

You wouldn't force all projects and changes to go through all those stages?

So what's wrong with the results?

PS on nolock => http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

Any reason why you do UNION instead of UNION ALL (union = SELECT DISTINCT * FROM all 3 queries combined)?

The R2 exams are not out YET?

So they start the exams once the product is out of support or something :hehe:

And I was referring to this >

I am thinking...

SQLRNNR (12/6/2011)

---

R2 certs are not yet out - but coming soon. I wouldn't expect to see the exams for 2012 for a couple of years.

For the time being, go...

I think those certs are out.

I'd go with 2008 R2 certs at the least if not 2012 (assuming they are out now, or very close to be out).

Check if switch works in a query.

If not embed all the iifs you need.

Edit : Wait are you runnin that query on the MS access engine or on sql server?

HTH, come back if you need more help or get stuck.

Grant Fritchey (12/6/2011)

---

LutzM (12/6/2011)

---

I guess I know...

LutzM (12/6/2011)

---

I guess I know why neither...

Read uncommitted would be useless here.

It's also a a bad practice most of the time.

If you can't say with 100% certainty that you can have the incorrect results returned then...

DECLARE @Id INT

SET @Id = (SELECT TOP 1 ID FROM <local system>)

INSERT INTO <local system> (columns list)

SELECT Columns, list FROM ServerName.DbName.owner.tblname WHERE Id > @Id

This assumes those dbs are on...

What's the PK? Identity by any change (or anything ever increasing would be nice)?

LutzM (12/6/2011)

---

Ninja's_RGR'us (12/6/2011)

---

ChrisM@Work (12/6/2011)

---

Ninja's_RGR'us (12/6/2011)

---

There's noone I recognize from this site,...

4 multiple value parameters. Good idea, but useles with @t.

@OP, can you...