I have a SQL Server View that does a UNION on some other Views in the database. The records in the views I'm referencing are unkeyed and many of the records are identical. When my View does a SELECT from those Views it seems to want to combine the identical records into a single record. Is this a default behavior in SQL Server and if so, how do I prevent it from happening?
Thanks,
Jon
Thanks,
Jon