RE: Return row values where exists in table, "not scanned" where missed scan

kabaari

SSCrazy

Points: 2235

July 10, 2014 at 11:56 am

#1728479

Lynn,

Thanks! Problem found, tested and resolved.

CREATE TABLE

[dbo].[Test_completedUnit](

[unit] [nvarchar](4) NOT NULL,

[operator] [nvarchar](50) NULL,

[SN] [varchar](50) PRIMARY KEY NOT NULL,

[Workorder][varchar](7)NOT NULL

)

INSERT INTO test_completedUnit

(unit, workorder, operator, sn)

SELECT '01','17879','VERHEY, CHARLES','05201417879001' UNION ALL

SELECT '02','17879','VERHEY, CHARLES','05201417879002' UNION ALL

SELECT '03','17879','VERHEY, CHARLES','05201417879003' UNION ALL

SELECT '04','17879','VERHEY, CHARLES','05201417879004' UNION ALL

SELECT '05','17879','VERHEY, CHARLES','05201417879005' UNION ALL

SELECT '06','17879','VERHEY, CHARLES','05201417879006' UNION ALL

SELECT '07','17879','VERHEY, CHARLES','05201417879007' UNION ALL

SELECT '08','17879','VERHEY, CHARLES','05201417879008' UNION ALL

SELECT '09','17879','VERHEY, CHARLES','05201417879009' UNION ALL

SELECT '10','17879','VERHEY, CHARLES','05201417879010' UNION ALL

SELECT '11','17879','VERHEY, CHARLES','05201417879011' UNION ALL

SELECT '12','17879','VERHEY, CHARLES','05201417879012' UNION ALL

SELECT '13','17879','VERHEY, CHARLES','05201417879013' UNION ALL

SELECT '14','17879','VERHEY, CHARLES','05201417879014' UNION ALL

SELECT '15','17879','VERHEY, CHARLES','05201417879015' UNION ALL

SELECT '16','17879','VERHEY, CHARLES','05201417879016' UNION ALL

SELECT '17','17879','VERHEY, CHARLES','05201417879017' UNION ALL

SELECT '18','17879','VERHEY, CHARLES','05201417879018' UNION ALL

SELECT '19','17879','VERHEY, CHARLES','05201417879019' UNION ALL

SELECT '20','17879','VERHEY, CHARLES','05201417879020' UNION ALL

SELECT '21','17879','VERHEY, CHARLES','05201417879021' UNION ALL

SELECT '22','17879','VERHEY, CHARLES','05201417879022' UNION ALL

SELECT '23','17879','VERHEY, CHARLES','05201417879023' UNION ALL

SELECT '24','17879','VERHEY, CHARLES','05201417879024' UNION ALL

SELECT '25','17879','VERHEY, CHARLES','05201417879025' UNION ALL

SELECT '26','17879','VERHEY, CHARLES','05201417879026' UNION ALL

SELECT '27','17879','VERHEY, CHARLES','05201417879027' UNION ALL

SELECT '28','17879','VERHEY, CHARLES','05201417879028' UNION ALL

SELECT '29','17879','VERHEY, CHARLES','05201417879029' UNION ALL

SELECT '30','17879','VERHEY, CHARLES','05201417879030'

CREATE TABLE [dbo].[Test_assemblyQC](

[SN] [nvarchar](16) NOT NULL,

[qcOperator] [nvarchar](20) NOT NULL,

[dateinspectedFP] [datetime] NULL,

[grFPDate] [datetime] NULL,

[hsOperator] [varchar](50) NULL,

[haOperator] [varchar](30) NULL,

[hadateFP] [datetime] NULL)

INSERT INTO Test_assemblyQC

(QCOperator, SN, grfpdate, haOperator, hadateFP, hsOperator, dateinspectedFP)

SELECT 'Roger Willet','05201417879003','May 29 2014 6:26PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:08AM' UNION ALL

SELECT 'Roger Willet','05201417879005','May 29 2014 6:31PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:13AM' UNION ALL

SELECT 'Roger Willet','05201417879006','May 29 2014 6:28PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:13AM' UNION ALL

SELECT 'Roger Willet','05201417879007','May 29 2014 6:33PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:14AM' UNION ALL

SELECT 'Roger Willet','05201417879008','May 29 2014 6:35PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:13AM' UNION ALL

SELECT 'Roger Willet','05201417879009','May 29 2014 6:38PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:14AM' UNION ALL

SELECT 'Roger Willet','05201417879010','May 29 2014 6:37PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:14AM' UNION ALL

SELECT 'Roger Willet','05201417879011','May 29 2014 6:41PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:19AM' UNION ALL

SELECT 'Roger Willet','05201417879012','May 29 2014 6:39PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:19AM' UNION ALL

SELECT 'Roger Willet','05201417879013','May 29 2014 6:44PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:19AM' UNION ALL

SELECT 'Roger Willet','05201417879014','May 29 2014 6:43PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:19AM' UNION ALL

SELECT 'Roger Willet','05201417879015','May 29 2014 7:54PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:19AM' UNION ALL

SELECT 'Roger Willet','05201417879017','May 29 2014 7:57PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:24AM' UNION ALL

SELECT 'Roger Willet','05201417879018','May 29 2014 7:56PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:24AM' UNION ALL

SELECT 'Roger Willet','05201417879019','May 29 2014 8:00PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:24AM' UNION ALL

SELECT 'Roger Willet','05201417879020','May 29 2014 7:59PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:24AM' UNION ALL

SELECT 'Roger Willet','05201417879021','May 29 2014 8:03PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:25AM' UNION ALL

SELECT 'Roger Willet','05201417879022','May 29 2014 8:01PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:25AM' UNION ALL

SELECT 'Roger Willet','05201417879023','May 29 2014 8:07PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:29AM' UNION ALL

SELECT 'Roger Willet','05201417879024','May 29 2014 8:05PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:29AM' UNION ALL

SELECT 'Roger Willet','05201417879025','May 29 2014 8:09PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:30AM' UNION ALL

SELECT 'Roger Willet','05201417879026','May 29 2014 8:08PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:30AM' UNION ALL

SELECT 'Roger Willet','05201417879027','May 29 2014 8:12PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:30AM' UNION ALL

SELECT 'Roger Willet','05201417879028','May 29 2014 8:12PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:30AM' UNION ALL

SELECT 'Roger Willet','05201417879029','May 29 2014 8:16PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:39AM' UNION ALL

SELECT 'Roger Willet','05201417879030','May 29 2014 8:14PM','Roger Snider','May 30 2014 12:00AM','Roger Snider','May 30 2014 6:39AM'