update tbl_EAI_inboundBatches set processingState ='all unmapped records' where ownerId = and ownerType = and batchId =

Aligning New Records to Relevant Manufacturers Aligning All Unlinked Records to Relevant Manufacturer

select queueId, operatorOwnerType, operatorOwnerId, operatorId, mapCompanyType, queueDate from tbl_1FS_MappingQueue with (nolock) where linkLevel = 0 and nullif( linkId, 0 ) is null and nullif( cdr_recordId, 0 ) is null order by queueId select queueId, operatorOwnerType, operatorOwnerId, operatorId, mapCompanyType, queueDate from qmd_totalMappingQueueRecord select companyName, address, city, state, zipcode from tbl_OPR_ClientOperators with (nolock) where fsltablecode = and ownerId = and operatorId = update tbl_1FS_MappingQueue set linkLevel = 99 where queueId = select operatorId from tbl_OPR_ClientOperators with (nolock) where ownerId = and fsltablecode = and nullif( fsl_choId, 0 ) = update tbl_1FS_MappingQueue set linkLevel = 2 where queueId = update tbl_1FS_MappingQueue set linkLevel = 1 where queueId = update tbl_1FS_MappingQueue set linkLevel = 2 where queueId = insert into tbl_1fs_MappingQueueHistory ( queueId, linkLevel, linkUserId, linkComment, linkStatus, linkDate, puntReason ) values ( , 2, -1, 'No Match', 'Z', , 'other' ) select top 1 queueId, operatorOwnerType, operatorOwnerId, operatorId, mapCompanyType, queueDate from tbl_1FS_MappingQueue with (nolock) where linkLevel = 0 and nullif( linkId, 0 ) is null and nullif( cdr_recordId, 0 ) is null order by queueId
Total Records Processed:#_totalRecordsProcessed#
Total Level 1 Records:#_totalLevel1Records#
Total Level 2 Records:#_totalLevel2Records#
Total Level 99 Records:#_totalLevel99Records#
Total Processing Time:#numberFormat( val( ( _endProcessor - _startProcessor ) / 60000 ), "0" )# minutes
#results#