You have an indexed view that uses a scalar SUM clause in Microsoft SQL Server 2014 or SQL Server 2012. After you perform an Insert or Delete operation on the view base table, the view returns incorrect results.
This problem was first fixed in the following cumulative updates for SQL Server:
- Cumulative Update 7 for SQL Server 2012 SP2
- Cumulative Update 1 for SQL Server 2014 Service Pack 1
- Cumulative Update 8 for SQL Server 2014
About cumulative updates for SQL Server
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 3067896 - Last Review: Jul 20, 2015 - Revision: 1