Processing Skipped for MFR Demo

Not Tastewise Library Account

select name from sys.tables where name =

#encodeforHTML( _resultsTable )# invalid, found #lsnumberformat( qmd_tableCheck.recordCount )#

select listName from tbl_LST_PartnerLists with (nolock) where listId = and ownerId = and ownerType = select email, firstName, lastName from tbl_Fspro_members with (nolock) where fspro_userId = select mfr_name from tblManufacturers with (nolock) where mfr_Id = select listId, listName, ownerId, ownerType, listType from tbl_LST_PartnerLists where ownerId = and ownerType = and listName = and partnerType = 'OPR' insert into tbl_LST_PartnerLists ( ownerType, ownerId, listName, partnerType, listType, createdBy ) values ( , , , 'OPR', 'SYSTEM', -1 ) select listId, listName, ownerId, ownerType, listType from tbl_LST_PartnerLists where ownerId = and ownerType = and listId = select sr.restaurantId, sr.name, sr.street, sr.city, sr.state, sr.zip, sr.country, opr.operatorId, opr.fsl_choId, sr.twc_id, sr.chain_name, sr.twd_id from [#_resultsTable#] sr with (nolock) left outer join tbl_OPR_ClientOperators opr with (nolock) on opr.ownerId = and opr.fsltablecode = and opr.mfrCustNum = sr.restaurantId select cho_id, cho_name, tastewiseId from tbl_CHO_Operators with (nolock) where tastewiseId = insert into tbl_OPR_ClientOperators( ownerId, fsltablecode, mfrCustNum, companyName, address, address2, countryId, city, state, zipcode, recordSource, lastImportSource, territoryId, fsl_choId, crmActive, dateCreated, lastUpdated, parentMFRCustNum, parentMFRCustName ) values ( , , , , , null, , , , , , , , , 'Y', , , , )

Client:	#encodeforHTML( qmd_mfr.mfr_name )#
Client:	#encodeforHTML( _searchAttrs.ownerType )##encodeForHTML( _searchAttrs.ownerId )#
Time:	#lsdateformat( qmd_batch.batchTime, "MM/dd/yyyy" )# #lstimeformat( qmd_batch.batchTime, "HH:mm TT" )#
User:	#encodeforhtml( qmd_user.firstName )# #encodeforHTML( qmd_user.lastName )# (#encodeforHTML( qmd_user.email )#
&##160;
Product List:	#encodeForHTML( _productSetName )#not set
Menu Search:	#encodeForHTML( _searchAttrs.apiParameters.menu_search )#
Menu Search:	not set
&##160;
Tastewise Returned:	#lsnumberformat( qmd_searchResults.recordCount )# records
List Name:	#encodeForHTML( _listName )#
&##160;
Existing Operators:	#lsnumberFormat( _existingOperators )# records
Existing Operators - Already Mapped:	#lsnumberFormat( _addedMapped )# records
Added Mapping Queued:	#lsnumberFormat( _addedQueued )# records
&##160;
Result Table:	#encodeForHTML( _resultsTable )#

insert into tbl_LST_partnerListItems( listId, partnerId ) select #_listId# listId, opr.operatorId as partnerId from [#_resultsTable#] sr with (nolock) inner join tbl_OPR_ClientOperators opr with (nolock) on opr.ownerId = and opr.fsltablecode = and opr.mfrCustNum = sr.restaurantId where not exists ( select * from tbl_LST_PartnerListItems pli where pli.listId = #_listId# and pli.partnerId = opr.operatorId ) declare @ownerId int = ; declare @ownerType varchar(3) = ; delete pli from tbl_LST_PartnerListItems pli inner join tbl_LST_PartnerLists pl on pl.ownerId = @ownerId and pl.ownerType = @ownerType and pl.listId = pli.listId and pl.partnerType = 'OPR' where not exists ( select * from tbl_OPR_ClientOperators opr where opr.ownerId = pl.ownerId and opr.fsltablecode = pl.ownerType and opr.operatorId = pli.partnerId ); delete pl from tbl_LST_PartnerLists pl where ownerId = @ownerId and ownerType = @ownerType and not exists ( select * from tbl_LST_PartnerListItems pli where pli.listId = pl.listId ); select state from tbl_UT_States with (nolock) where stateFull = and countryId = select countryId from tbl_UT_Countries with (nolock) where country =