Usage of INTERSECT ALL and EXCEPT ALL

[dnoeth]

Hi there,
i'd like to know if anyone ever wrote a query including INTERSECT ALL or EXCEPT ALL?
I know how it works and what result set it produces, but i've never found a problem to be solved with it. Or maybe i just didn't recognize it, because i never used it before ;-(

So i'd really like to know about any real world examples...

Dieter

 

[BillDHS]

I have only used except once, to find records in a table that weren't in a copy of that table. I believe that situation had to do with test vs production, or backup vs production, or the updates to a table.

At the time I thought it worked slick and I would use it more frequently, but I haven't.