I want to compare two SQL Views in SQL Server 2005 and get the difference.
I have two views:
Compare View2 against View1 and get the unmatched values from View2.
(I do not have sufficient permission to create constraints in my tables, so I created Views from the table).
Thanks and appreciate any help.