I have a view that selects data from a table that is showing different data.
The table is
dbo.user, the view is
dbo.users (don't judge, I inherited this system). The view is simply
select * from table.
If I run the following statements:
SELECT Field1, Field2 FROM dbo.[User] WITH (NOLOCK) ORDER BY Field1; SELECT Field1, Field2 FROM dbo.Users WITH (NOLOCK) ORDER BY Field1;
I get different values for one of the fields. See the attached pic:
Any ideas how this happens? The table is clustered, has a pk and unique index.