If some of the views reference the same tables you may want to consider rewriting the query entirely to run without views.

Paul, I think you missed something in the midgame posts. His question is really why it didn't throw a syntax error when he used = to compare...

Revised modest proposal: Carry katana and wakazashi on your person at all times.

Respectfully, it wasn't clear. I read it the same way sturner did at first.

Alvin Ramard (10/12/2010)

---

The Dixie Flatline (10/12/2010)

---

Modest proposal for you, Gail: Take your katana and wakazashi to the next meeting.

Just lay them on the table...

Modest proposal for you, Gail: Take your katana and wakazashi to the next meeting.

Just lay them on the table and proceed to discuss things...

Not after you groaned at my joke.

This is an American joke I just had to add here. You both deserve time off for GUID behavior.

It not only reads easier, it should be child's play to generate dynamically as well.

Jeff, you should check out this thread. It's about a year old, but it...

Whatever the percentages, all you guys (and gals) are awesome.

One alternative is the old school way: Do a summary query.

GROUP BY all the columns used to determine a duplicate . Store all results...

If I correctly understand what you are trying to do, the attached dynamic SQL code would do the trick for you. But I'm not sure this is...

I just had an idea for an epic summer movie. It involves an intrepid group of DBA's and SQL Developers who get sent back to prehistoric...

Alvin, I couldn't exclude you...

Thanks to everyone for sharing your knowledge, insight, humor, and support.