update tbl_EAI_inboundBatches set processingState ='all unmapped records' where ownerId = and ownerType = and batchId = select queueId, operatorOwnerType, operatorOwnerId, cdr_recordId, mapCompanyType from tbl_1FS_MappingQueue with (nolock) where linkLevel = 0 and nullif( linkId, 0 ) is null and nullif( operatorId, 0 ) is null order by queueId select queueId, operatorOwnerType, operatorOwnerId, cdr_recordId, mapCompanyType from qmd_totalMappingQueueRecord select cdr_dstname as companyName, cdr_dstaddress1 as address, cdr_dstcity as city, cdr_dststate as state, cdr_dstzip as zipcode from tbl_CDR_Distributors with (nolock) where fsl_tablecode = and ownerId = and cdr_recordId = update tbl_1FS_MappingQueue set linkLevel = 99 where queueId = select cdr_recordId from tbl_CDR_Distributors with (nolock) where ownerId = and fsl_tablecode = and nullif( fsl_dstId, 0 ) = 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, cdr_recordId, mapCompanyType from tbl_1FS_MappingQueue with (nolock) where linkLevel = 0 and nullif( linkId, 0 ) is null and nullif( operatorId, 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#