When I run the report for a few days then its good. but if I try to retrive data for more then a year then I get this error message.
I tried to run DBCC CHECKDB as it says in the error, but after 10 min running a error came up that it can't continue.
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:952663; actual 2668:-1594740640). It occurred during a read of page (1:952663) in database ID 5 at offset 0x000001d12ae000 in file 'F:\Data\PointOfSale.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.