Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE `xxxx`.`ONLINEINFOAUX`
- SET `IRIS_ITEM_NUMBER` = @IRIS_ITEM_NUMBER
- , `UPC` = @UPC
- , `ONLINE_DESCRIPTION` = @ONLINE_DESCRIPTION
- , `ONLINE_MARKDOWN_DESCRIPTION` = @ONLINE_MARKDOWN_DESCRIPTION
- , `ONLINE_MARKDOWN_DESCRIPTION_NOAUTOUPDATE` = @ONLINE_MARKDOWN_DESCRIPTION_NOAUTOUPDATE
- , `ONLINE_ALLERGENS_DESCRIPTION` = @ONLINE_ALLERGENS_DESCRIPTION
- , `ONLINE_INGREDIENTS_DESCRIPTION` = @ONLINE_INGREDIENTS_DESCRIPTION
- , `CALC_CATEGORY` = @CALC_CATEGORY
- , `CALC_SIZE` = @CALC_SIZE
- , `MIN_SIZE` = @MIN_SIZE
- , `MAX_SIZE` = @MAX_SIZE
- , `SIZE` = @SIZE
- , `UOM` = @UOM
- , `CHAINWIDEITEMOFF` = @CHAINWIDEITEMOFF
- , `PACKAGE` = @PACKAGE
- , `PACK_INFO` = @PACK_INFO
- , `IMAGES_URLS` = @IMAGES_URLS
- , `SERVINGSPERCONTAINER_VALUES` = @SERVINGSPERCONTAINER_VALUES
- , `SERVINGSIZE_VALUES` = @SERVINGSIZE_VALUES
- , `CALORIES_VALUES` = @CALORIES_VALUES
- , `TOTALFAT_VALUES` = @TOTALFAT_VALUES
- , `SATURATEDFAT_VALUES` = @SATURATEDFAT_VALUES
- , `TRANSFAT_VALUES` = @TRANSFAT_VALUES
- , `CHOLESTEROL_VALUES` = @CHOLESTEROL_VALUES
- , `SODIUM_VALUES` = @SODIUM_VALUES
- , `TOTALCARBOHYDRATE_VALUES` = @TOTALCARBOHYDRATE_VALUES
- , `DIETARYFIBER_VALUES` = @DIETARYFIBER_VALUES
- , `TOTALSUGARS_VALUES` = @TOTALSUGARS_VALUES
- , `ADDEDSUGARS_VALUES` = @ADDEDSUGARS_VALUES
- , `PROTEIN_VALUES` = @PROTEIN_VALUES
- , `VITAMIND_VALUES` = @VITAMIND_VALUES
- , `CALCIUM_VALUES` = @CALCIUM_VALUES
- , `POTASSIUM_VALUES` = @POTASSIUM_VALUES
- , `IRON_VALUES` = @IRON_VALUES
- , `ADDEDSUGARS_PERCENT` = @ADDEDSUGARS_PERCENT
- , `SERVINGSIZE_PERCENT` = @SERVINGSIZE_PERCENT
- , `CALORIES_PERCENT` = @CALORIES_PERCENT
- , `TOTALFAT_PERCENT` = @TOTALFAT_PERCENT
- , `SATURATEDFAT_PERCENT` = @SATURATEDFAT_PERCENT
- , `CHOLESTEROL_PERCENT` = @CHOLESTEROL_PERCENT
- , `SODIUM_PERCENT` = @SODIUM_PERCENT
- , `TOTALCARBOHYDRATE_PERCENT` = @TOTALCARBOHYDRATE_PERCENT
- , `DIETARYFIBER_PERCENT` = @DIETARYFIBER_PERCENT
- , `VITAMIND_PERCENT` = @VITAMIND_PERCENT
- , `CALCIUM_PERCENT` = @CALCIUM_PERCENT
- , `POTASSIUM_PERCENT` = @POTASSIUM_PERCENT
- , `IRON_PERCENT` = @IRON_PERCENT
- , `IMAGES_SOURCE` = @IMAGES_SOURCE
- , `IMAGES_NAMES` = @IMAGES_NAMES
- , `IMAGES_URL` = @IMAGES_URL
- , `IMAGES_DATES` = @IMAGES_DATES
- , `IMAGES_MD5SUM` = @IMAGES_MD5SUM
- , `MARKETINGCUTOFF` = @MARKETINGCUTOFF
- , `LINKEDCATEGORIES` = @LINKEDCATEGORIES
- , `OVERRIDE_KWIKEE` = @OVERRIDE_KWIKEE
- , `FULFILLMENT_SORTING_ID` = @FULFILLMENT_SORTING_ID
- WHERE ((`COMMON_ITEM_NUMBER` = @Original_COMMON_ITEM_NUMBER) AND (`IRIS_ITEM_NUMBER` = @Original_IRIS_ITEM_NUMBER) AND ((@IsNull_UPC = 1 AND `UPC` IS NULL) OR (`UPC` = @Original_UPC)) AND ((@IsNull_ONLINE_MARKDOWN_DESCRIPTION_NOAUTOUPDATE = 1 AND `ONLINE_MARKDOWN_DESCRIPTION_NOAUTOUPDATE` IS NULL) OR (`ONLINE_MARKDOWN_DESCRIPTION_NOAUTOUPDATE` = @Original_ONLINE_MARKDOWN_DESCRIPTION_NOAUTOUPDATE)) AND ((@IsNull_CALC_SIZE = 1 AND `CALC_SIZE` IS NULL) OR (`CALC_SIZE` = @Original_CALC_SIZE)) AND ((@IsNull_MIN_SIZE = 1 AND `MIN_SIZE` IS NULL) OR (`MIN_SIZE` = @Original_MIN_SIZE)) AND ((@IsNull_MAX_SIZE = 1 AND `MAX_SIZE` IS NULL) OR (`MAX_SIZE` = @Original_MAX_SIZE)) AND ((@IsNull_SIZE = 1 AND `SIZE` IS NULL) OR (`SIZE` = @Original_SIZE)) AND ((@IsNull_UOM = 1 AND `UOM` IS NULL) OR (`UOM` = @Original_UOM)) AND ((@IsNull_CHAINWIDEITEMOFF = 1 AND `CHAINWIDEITEMOFF` IS NULL) OR (`CHAINWIDEITEMOFF` = @Original_CHAINWIDEITEMOFF)) AND ((@IsNull_PACKAGE = 1 AND `PACKAGE` IS NULL) OR (`PACKAGE` = @Original_PACKAGE)) AND ((@IsNull_PACK_INFO = 1 AND `PACK_INFO` IS NULL) OR (`PACK_INFO` = @Original_PACK_INFO)) AND ((@IsNull_SERVINGSPERCONTAINER_VALUES = 1 AND `SERVINGSPERCONTAINER_VALUES` IS NULL) OR (`SERVINGSPERCONTAINER_VALUES` = @Original_SERVINGSPERCONTAINER_VALUES)) AND ((@IsNull_SERVINGSIZE_VALUES = 1 AND `SERVINGSIZE_VALUES` IS NULL) OR (`SERVINGSIZE_VALUES` = @Original_SERVINGSIZE_VALUES)) AND ((@IsNull_CALORIES_VALUES = 1 AND `CALORIES_VALUES` IS NULL) OR (`CALORIES_VALUES` = @Original_CALORIES_VALUES)) AND ((@IsNull_TOTALFAT_VALUES = 1 AND `TOTALFAT_VALUES` IS NULL) OR (`TOTALFAT_VALUES` = @Original_TOTALFAT_VALUES)) AND ((@IsNull_SATURATEDFAT_VALUES = 1 AND `SATURATEDFAT_VALUES` IS NULL) OR (`SATURATEDFAT_VALUES` = @Original_SATURATEDFAT_VALUES)) AND ((@IsNull_TRANSFAT_VALUES = 1 AND `TRANSFAT_VALUES` IS NULL) OR (`TRANSFAT_VALUES` = @Original_TRANSFAT_VALUES)) AND ((@IsNull_CHOLESTEROL_VALUES = 1 AND `CHOLESTEROL_VALUES` IS NULL) OR (`CHOLESTEROL_VALUES` = @Original_CHOLESTEROL_VALUES)) AND ((@IsNull_SODIUM_VALUES = 1 AND `SODIUM_VALUES` IS NULL) OR (`SODIUM_VALUES` = @Original_SODIUM_VALUES)) AND ((@IsNull_TOTALCARBOHYDRATE_VALUES = 1 AND `TOTALCARBOHYDRATE_VALUES` IS NULL) OR (`TOTALCARBOHYDRATE_VALUES` = @Original_TOTALCARBOHYDRATE_VALUES)) AND ((@IsNull_DIETARYFIBER_VALUES = 1 AND `DIETARYFIBER_VALUES` IS NULL) OR (`DIETARYFIBER_VALUES` = @Original_DIETARYFIBER_VALUES)) AND ((@IsNull_TOTALSUGARS_VALUES = 1 AND `TOTALSUGARS_VALUES` IS NULL) OR (`TOTALSUGARS_VALUES` = @Original_TOTALSUGARS_VALUES)) AND ((@IsNull_ADDEDSUGARS_VALUES = 1 AND `ADDEDSUGARS_VALUES` IS NULL) OR (`ADDEDSUGARS_VALUES` = @Original_ADDEDSUGARS_VALUES)) AND ((@IsNull_PROTEIN_VALUES = 1 AND `PROTEIN_VALUES` IS NULL) OR (`PROTEIN_VALUES` = @Original_PROTEIN_VALUES)) AND ((@IsNull_VITAMIND_VALUES = 1 AND `VITAMIND_VALUES` IS NULL) OR (`VITAMIND_VALUES` = @Original_VITAMIND_VALUES)) AND ((@IsNull_CALCIUM_VALUES = 1 AND `CALCIUM_VALUES` IS NULL) OR (`CALCIUM_VALUES` = @Original_CALCIUM_VALUES)) AND ((@IsNull_POTASSIUM_VALUES = 1 AND `POTASSIUM_VALUES` IS NULL) OR (`POTASSIUM_VALUES` = @Original_POTASSIUM_VALUES)) AND ((@IsNull_IRON_VALUES = 1 AND `IRON_VALUES` IS NULL) OR (`IRON_VALUES` = @Original_IRON_VALUES)) AND ((@IsNull_ADDEDSUGARS_PERCENT = 1 AND `ADDEDSUGARS_PERCENT` IS NULL) OR (`ADDEDSUGARS_PERCENT` = @Original_ADDEDSUGARS_PERCENT)) AND ((@IsNull_SERVINGSIZE_PERCENT = 1 AND `SERVINGSIZE_PERCENT` IS NULL) OR (`SERVINGSIZE_PERCENT` = @Original_SERVINGSIZE_PERCENT)) AND ((@IsNull_CALORIES_PERCENT = 1 AND `CALORIES_PERCENT` IS NULL) OR (`CALORIES_PERCENT` = @Original_CALORIES_PERCENT)) AND ((@IsNull_TOTALFAT_PERCENT = 1 AND `TOTALFAT_PERCENT` IS NULL) OR (`TOTALFAT_PERCENT` = @Original_TOTALFAT_PERCENT)) AND ((@IsNull_SATURATEDFAT_PERCENT = 1 AND `SATURATEDFAT_PERCENT` IS NULL) OR (`SATURATEDFAT_PERCENT` = @Original_SATURATEDFAT_PERCENT)) AND ((@IsNull_CHOLESTEROL_PERCENT = 1 AND `CHOLESTEROL_PERCENT` IS NULL) OR (`CHOLESTEROL_PERCENT` = @Original_CHOLESTEROL_PERCENT)) AND ((@IsNull_SODIUM_PERCENT = 1 AND `SODIUM_PERCENT` IS NULL) OR (`SODIUM_PERCENT` = @Original_SODIUM_PERCENT)) AND ((@IsNull_TOTALCARBOHYDRATE_PERCENT = 1 AND `TOTALCARBOHYDRATE_PERCENT` IS NULL) OR (`TOTALCARBOHYDRATE_PERCENT` = @Original_TOTALCARBOHYDRATE_PERCENT)) AND ((@IsNull_DIETARYFIBER_PERCENT = 1 AND `DIETARYFIBER_PERCENT` IS NULL) OR (`DIETARYFIBER_PERCENT` = @Original_DIETARYFIBER_PERCENT)) AND ((@IsNull_VITAMIND_PERCENT = 1 AND `VITAMIND_PERCENT` IS NULL) OR (`VITAMIND_PERCENT` = @Original_VITAMIND_PERCENT)) AND ((@IsNull_CALCIUM_PERCENT = 1 AND `CALCIUM_PERCENT` IS NULL) OR (`CALCIUM_PERCENT` = @Original_CALCIUM_PERCENT)) AND ((@IsNull_POTASSIUM_PERCENT = 1 AND `POTASSIUM_PERCENT` IS NULL) OR (`POTASSIUM_PERCENT` = @Original_POTASSIUM_PERCENT)) AND ((@IsNull_IRON_PERCENT = 1 AND `IRON_PERCENT` IS NULL) OR (`IRON_PERCENT` = @Original_IRON_PERCENT)) AND ((@IsNull_IMAGES_SOURCE = 1 AND `IMAGES_SOURCE` IS NULL) OR (`IMAGES_SOURCE` = @Original_IMAGES_SOURCE)) AND ((@IsNull_MARKETINGCUTOFF = 1 AND `MARKETINGCUTOFF` IS NULL) OR (`MARKETINGCUTOFF` = @Original_MARKETINGCUTOFF)) AND ((@IsNull_OVERRIDE_KWIKEE = 1 AND `OVERRIDE_KWIKEE` IS NULL) OR (`OVERRIDE_KWIKEE` = @Original_OVERRIDE_KWIKEE)) AND ((@IsNull_FULFILLMENT_SORTING_ID = 1 AND `FULFILLMENT_SORTING_ID` IS NULL) OR (`FULFILLMENT_SORTING_ID` = @Original_FULFILLMENT_SORTING_ID)))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement