how to use sql query for optimizing application

Question

Hi Team

 

I have a query that checks for units being read and misread. Now the query works fine, how will implement this query to be readable to people in the existing application(windows application)? I was advice that using store procedured to the database table will break this windows application completely.

 

// Requirement

The production shift leader(s) are finding that the total is not reflecting the correct number of units processed at the end of lego line and need to have a check in place to validate the units counted

SELECT TOP 1000
      [Production Year]
      ,[PNR]
      ,[KNR]
      ,[Transaction Code]
      ,[DateTime Passed]
      ,[EQS Carstate]
      ,[SeqNum]
  FROM [Tracking_Server_DB].[dbo].[Checkpoint Movement]
  WHERE [Transaction Code] like '%T0013' and
  [DateTime Passed] between '2021-05-11 06:00:00' and '2021-05-11 19:59:59'
  and PNR not in
  (SELECT PNR
  FROM [Tracking_Server_DB].[dbo].[Checkpoint Movement]
  WHERE [Transaction Code] like '%T0067%' and
  [DateTime Passed] between '2021-05-11 06:00:00' and '2021-05-11 19:59:59')
  Order  by [DateTime Passed]

// Output of this query is as image.