UPDATE tbl_OPR_ClientOperators SET priceCategory = , features = , specialevents = , primaryMenuKnown4 = , primaryVenueKnown4 = , addtnlMenuKywrd = , addtnlVenueKywrd = , phone = , url = , yearOpen = , monthOpen = , banquetCateringComments = , banquetMin = , banquetMax = , cateringMin = , cateringMax = , lastUpdated = {fn now()} , profile = WHERE operatorId = AND ownerId = AND fsltablecode = UPDATE tbl_FSPRO_Members SET firstname = , lastname = , title = , email = WHERE fspro_userid = INSERT INTO tbl_FSPRO_Members ( ownerId, fsl_tablecode, title, firstname, lastname, orgId, orgType, email, fspro_password, recState, emailYesNo, CountryId, LoginEnabled ) VALUES ( 99, 'MSC', , , , , 'OPR', , , 'A', 1, 27, 1 ) UPDATE tbl_OPR_ClientOperators SET primaryContactId = WHERE ownerId = AND fsltablecode = AND operatorId = SELECT * FROM tbl_MVU_FoodTruckLocations WHERE operatorId = AND ownerId = AND ownerType = UPDATE tbl_MVU_FoodTruckLocations SET sundayAddress = , mondayAddress = , tuesdayAddress = , wednesdayAddress = , thursdayAddress = , fridayAddress = , saturdayAddress = WHERE operatorId = AND ownerId = AND ownerType = INSERT INTO tbl_MVU_FoodTruckLocations ( ownerId, ownerType, operatorId, sundayAddress, mondayAddress, tuesdayAddress, wednesdayAddress, thursdayAddress, fridayAddress, saturdayAddress ) VALUES ( , , , , , , , , , ) SELECT * FROM tbl_MVU_KitchenHours WHERE OperatorId = AND OwnerId = AND OwnerType = INSERT INTO tbl_MVU_KitchenHours (ownerId, ownerType, operatorId) VALUES (,,) UPDATE tbl_MVU_KitchenHours SET monday = , tuesday = , wednesday = , thursday = , friday = , saturday = , sunday = , thanksgiving = , easter = , mothersday = , newyearseve = , newyearsday = , christmaseve = , christmasday = , independenceday = , laborday = , memorialday = , mondayComments = , tuesdayComments = , wednesdayComments = , thursdayComments = , fridayComments = , saturdayComments = , sundayComments = , kitchenHourComments = WHERE OperatorId = AND OwnerId = AND OwnerType = select firstname + ' ' + lastname as fullname FROM tbl_FSPRO_Members WHERE fspro_userId = SELECT selectionLabel FROM qmd_getFeatures WHERE selectionValue IN () SELECT selectionLabel FROM qmd_getFeatures WHERE selectionValue IN () SELECT selectionLabel FROM qmd_getPriceCategories WHERE selectionValue IN () SELECT selectionLabel FROM qmd_getPriceCategories WHERE selectionValue IN () SELECT selectionLabel FROM qmd_getSpecialEvents WHERE selectionValue IN () SELECT selectionLabel FROM qmd_getSpecialEvents WHERE selectionValue IN () #qmd_getUpdater.fullname# updated #qmd_opr.companyName#
#qmd_opr.address# #qmd_opr.city# ( #qmd_opr.operatorId# ) via The Owner's App

style="background:yellow;">style="background:yellow;">style="background:yellow;">style="background:yellow;">style="background:yellow;">style="background:yellow;">style="background:yellow;">style="background:yellow;">style="background:yellow;">style="background:yellow;">style="background:yellow;">style="background:yellow;">style="background:yellow;">
FieldPrevious ValueCurrent Value
Menu#qmd_opr.menu##qmd_newOpr.menu#
Venue#qmd_opr.venue##qmd_newOpr.venue#
Menu Keywords#qmd_opr.addtnlMenuKywrd##qmd_newOpr.addtnlMenuKywrd#
Venue Keywords#qmd_opr.addtnlVenueKywrd##qmd_newOpr.addtnlVenueKywrd#
Cuisine#qmd_opr.cuisine##qmd_newOpr.cuisine#
Price#qmd_getPriceCategoryBefore.selectionLabel##qmd_getPriceCategoryAfter.selectionLabel#
Features#ValueList(qmd_getFeaturesBefore.selectionLabel)##ValueList(qmd_getFeaturesAfter.selectionLabel)#
Special Events#ValueList(qmd_getSpecialEventsBefore.selectionLabel)##ValueList(qmd_getSpecialEventsAfter.selectionLabel)#
Year Open#qmd_opr.yearOpen##qmd_newOpr.yearOpen#
Month Open#qmd_opr.monthOpen##qmd_newOpr.monthOpen#
Phone#qmd_opr.phone##qmd_newOpr.phone#
Website#qmd_opr.url##qmd_newOpr.url#
Kitchen Hours style="background:yellow;"> style="background:yellow;"> style="background:yellow;"> style="background:yellow;"> style="background:yellow;"> style="background:yellow;"> style="background:yellow;">
Sunday#qmd_opr.sunday##qmd_newOpr.sunday#
Monday#qmd_opr.monday##qmd_newOpr.monday#
Tuesday#qmd_opr.tuesday##qmd_newOpr.tuesday#
Wednesday#qmd_opr.wednesday##qmd_newOpr.wednesday#
Thursday#qmd_opr.thursday##qmd_newOpr.thursday#
Friday#qmd_opr.friday##qmd_newOpr.friday#
Saturday#qmd_opr.saturday##qmd_newOpr.saturday#
Holiday Hours style="background:yellow;"> style="background:yellow;"> style="background:yellow;"> style="background:yellow;"> style="background:yellow;"> style="background:yellow;"> style="background:yellow;"> style="background:yellow;"> style="background:yellow;"> style="background:yellow;">
Easter#qmd_opr.easter##qmd_newOpr.easter#
Thanksgiving#qmd_opr.thanksgiving##qmd_newOpr.thanksgiving#
Mothers Day#qmd_opr.mothersday##qmd_newOpr.mothersday#
Christmas Eve#qmd_opr.christmaseve##qmd_newOpr.christmaseve#
Christmas Day#qmd_opr.christmasday##qmd_newOpr.christmasday#
New Years Eve#qmd_opr.newyearseve##qmd_newOpr.newyearseve#
New Years Day#qmd_opr.newyearsday##qmd_newOpr.newyearsday#
Memorial Day#qmd_opr.memorialday##qmd_newOpr.memorialday#
Labor Day#qmd_opr.laborday##qmd_newOpr.laborday#
Independence Day#qmd_opr.independenceday##qmd_newOpr.independenceday#
Banquet & Catering Comments #HtmlEditFormat(qmd_opr.banquetCateringComments)# #HtmlEditFormat(qmd_newOpr.banquetCateringComments)#
Daily Specials style="background:yellow;">style="background:yellow;">style="background:yellow;">style="background:yellow;">style="background:yellow;">style="background:yellow;">style="background:yellow;">
Sunday Specials#qmd_opr.sundayComments##qmd_newOpr.sundayComments#
Monday Specials#qmd_opr.mondayComments##qmd_newOpr.mondayComments#
Tuesday Specials#qmd_opr.tuesdayComments##qmd_newOpr.tuesdayComments#
Wednesday Specials#qmd_opr.wednesdayComments#
Thursday Specials#qmd_opr.thursdayComments##qmd_newOpr.thursdayComments#
Friday Specials#qmd_opr.fridayComments##qmd_newOpr.fridayComments#
Saturday Specials#qmd_opr.saturdayComments##qmd_newOpr.saturdayComments#
Primary Contact style="background:yellow;">style="background:yellow;">style="background:yellow;">style="background:yellow;">
Contact Title#qmd_opr.title##qmd_newOpr.title#
Contact Firstname#qmd_opr.firstname##qmd_newOpr.firstname#
Contact Lastname#qmd_opr.lastname##qmd_newOpr.lastname#
Contact E-mail#qmd_opr.email##qmd_newOpr.email#