Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  Data Corruption Issues  Ghost duplicate records

Author  Topic  dtimo Starting Member 1 Post Posted - 2009-11-12 : 20:54:12 A view will not show any results that use a particular record. A user used a form to partially create a record (Nulls permitted) then abandoned it. She tried again but kind of screwed up the data. I went into the table via visual studio and deleted the attempts and created the record. The problem is that a view using that table shows no rows where that record is used. I am pretty new to this but the results seem to be as if I had a duplicate record.