Cliff Jones (3/22/2011)
Interesting, I did not realize that the Table Value Constructor behaved like a UNION. It makes sense now that it has been pointed out.
Great Question. I also have not used SQL 2008 new features enough to see this happen yet.
Thanks for pointing that out.