how to use sql query for optimizing application

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jefferson S. Motta5y ago
Accepted answer
Hi,

I recommend you to use "Network Library=DBNMPNTW;" on Windows Application if you are using SQL Server and Windows.

Here I talk about:

Improve SQL Server Connection Performance In ADO.NET (c-sharpcorner.com)