Applicatio not pulling the last record

BKAN 41 Reputation points
2022-10-18T13:47:11.317+00:00

Hi All,
We have an application that connects to the database and pulls the records from a table. The issue is out of 100 rows it only reads 99 and misses the last record, but for some strange reason it reads the last row just before midnight, not sure what is happening , any advice please.
Thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,093 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,580 questions
{count} votes