12:34:22 PM Sunday, May 29, 2022|   SELECT filename, 
                    MAX(
	                    CASE update_date
		                    WHEN ''
			                    THEN CAST(create_date as decimal)
		                    ELSE CAST(update_date as decimal)
	                    END
	                    ) AS maxdate
                    FROM Schedule 
                    GROUP BY filename
                    HAVING maxdate < 220429
                    
12:34:22 PM Sunday, May 29, 2022|   SELECT s.filename
	                    , MAX(
		                    CASE s.update_date
			                    WHEN ''
				                    THEN CAST(s.create_date as decimal)
			                    ELSE CAST(s.update_date as decimal)
		                    END
	                    ) AS maxdate
                    FROM Schedule s
                    INNER JOIN
                    (
	                    SELECT filename 
		                    , MIN(status) AS status
		                    , count(*) AS c
	                    FROM
	                    (
		                    SELECT filename, status, count(*)
		                    FROM
		                    (
			                    SELECT filename, 
				                    CASE status
                                        WHEN 'OK'
                                            THEN 'WORKING'
                                        WHEN 'Complete'
                                            THEN 'OK'
						                WHEN ''
							                THEN CASE status1
								                WHEN 'OK'
									                THEN 'WORKING'
								                WHEN 'Complete'
									                THEN 'WORKING'
								                WHEN 'NG'
									                THEN 'NG'
								                ELSE status1
								                END
                                        ELSE status
                                        END status
			                    FROM Schedule
		                    ) a
		                    GROUP BY filename, status
	                    )
	                    GROUP BY filename
	                    HAVING status = 'OK'
	                    AND c = 1
                    ) a
                    ON a.filename = s.filename
                    GROUP BY s.filename
                    HAVING maxdate < 220519
                    
12:34:23 PM Sunday, May 29, 2022|   DELETE
                    FROM Undetect_sno 
                    WHERE CAST(create_date as decimal) < 220519
                    
12:35:42 PM Sunday, May 29, 2022| Data size:20
[Report] 
Number of digits:20
result:B0113-250110 005 019
Code type:11
Is it a composite:0
Quality:100
Details:49
Code synthesis:0
[QR] 
Read result position:0
Parity:0
Total number of concatenations:0

12:35:42 PM Sunday, May 29, 2022| OnScan: result=B0113-250110 005 019, scanStep=0
12:35:42 PM Sunday, May 29, 2022|    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, TdsParserState state)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, TdsParserState state)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand cmdHandler, SqlDataReader dataStream)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at SCAN.lib.MsSql.insert(String sql)
   at SCAN.Form_Matching.btScanLib_OnScan(String result)
   at SCAN.lib.BtScanLib.ScanData_once()
   at SCAN.lib.BtScanLib.WndProc(Message& msg)
   at Microsoft.WindowsCE.Forms.MessageWindow._WndProc(Message& msg)
   at Microsoft.AGL.Forms.EVL.EnterMainLoop(IntPtr hwnMain)
   at System.Windows.Forms.Application.Run(Form fm)
   at SCAN.Program.Main()

