Advertisement
penright

Untitled

Jul 31st, 2023
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.64 KB | None | 0 0
  1. UPDATE `xxxx`.`ONLINEINFOAUX`
  2. SET `IRIS_ITEM_NUMBER` = @IRIS_ITEM_NUMBER
  3. , `UPC` = @UPC
  4. , `ONLINE_DESCRIPTION` = @ONLINE_DESCRIPTION
  5. , `ONLINE_MARKDOWN_DESCRIPTION` = @ONLINE_MARKDOWN_DESCRIPTION
  6. , `ONLINE_MARKDOWN_DESCRIPTION_NOAUTOUPDATE` = @ONLINE_MARKDOWN_DESCRIPTION_NOAUTOUPDATE
  7. , `ONLINE_ALLERGENS_DESCRIPTION` = @ONLINE_ALLERGENS_DESCRIPTION
  8. , `ONLINE_INGREDIENTS_DESCRIPTION` = @ONLINE_INGREDIENTS_DESCRIPTION
  9. , `CALC_CATEGORY` = @CALC_CATEGORY
  10. , `CALC_SIZE` = @CALC_SIZE
  11. , `MIN_SIZE` = @MIN_SIZE
  12. , `MAX_SIZE` = @MAX_SIZE
  13. , `SIZE` = @SIZE
  14. , `UOM` = @UOM
  15. , `CHAINWIDEITEMOFF` = @CHAINWIDEITEMOFF
  16. , `PACKAGE` = @PACKAGE
  17. , `PACK_INFO` = @PACK_INFO
  18. , `IMAGES_URLS` = @IMAGES_URLS
  19. , `SERVINGSPERCONTAINER_VALUES` = @SERVINGSPERCONTAINER_VALUES
  20. , `SERVINGSIZE_VALUES` = @SERVINGSIZE_VALUES
  21. , `CALORIES_VALUES` = @CALORIES_VALUES
  22. , `TOTALFAT_VALUES` = @TOTALFAT_VALUES
  23. , `SATURATEDFAT_VALUES` = @SATURATEDFAT_VALUES
  24. , `TRANSFAT_VALUES` = @TRANSFAT_VALUES
  25. , `CHOLESTEROL_VALUES` = @CHOLESTEROL_VALUES
  26. , `SODIUM_VALUES` = @SODIUM_VALUES
  27. , `TOTALCARBOHYDRATE_VALUES` = @TOTALCARBOHYDRATE_VALUES
  28. , `DIETARYFIBER_VALUES` = @DIETARYFIBER_VALUES
  29. , `TOTALSUGARS_VALUES` = @TOTALSUGARS_VALUES
  30. , `ADDEDSUGARS_VALUES` = @ADDEDSUGARS_VALUES
  31. , `PROTEIN_VALUES` = @PROTEIN_VALUES
  32. , `VITAMIND_VALUES` = @VITAMIND_VALUES
  33. , `CALCIUM_VALUES` = @CALCIUM_VALUES
  34. , `POTASSIUM_VALUES` = @POTASSIUM_VALUES
  35. , `IRON_VALUES` = @IRON_VALUES
  36. , `ADDEDSUGARS_PERCENT` = @ADDEDSUGARS_PERCENT
  37. , `SERVINGSIZE_PERCENT` = @SERVINGSIZE_PERCENT
  38. , `CALORIES_PERCENT` = @CALORIES_PERCENT
  39. , `TOTALFAT_PERCENT` = @TOTALFAT_PERCENT
  40. , `SATURATEDFAT_PERCENT` = @SATURATEDFAT_PERCENT
  41. , `CHOLESTEROL_PERCENT` = @CHOLESTEROL_PERCENT
  42. , `SODIUM_PERCENT` = @SODIUM_PERCENT
  43. , `TOTALCARBOHYDRATE_PERCENT` = @TOTALCARBOHYDRATE_PERCENT
  44. , `DIETARYFIBER_PERCENT` = @DIETARYFIBER_PERCENT
  45. , `VITAMIND_PERCENT` = @VITAMIND_PERCENT
  46. , `CALCIUM_PERCENT` = @CALCIUM_PERCENT
  47. , `POTASSIUM_PERCENT` = @POTASSIUM_PERCENT
  48. , `IRON_PERCENT` = @IRON_PERCENT
  49. , `IMAGES_SOURCE` = @IMAGES_SOURCE
  50. , `IMAGES_NAMES` = @IMAGES_NAMES
  51. , `IMAGES_URL` = @IMAGES_URL
  52. , `IMAGES_DATES` = @IMAGES_DATES
  53. , `IMAGES_MD5SUM` = @IMAGES_MD5SUM
  54. , `MARKETINGCUTOFF` = @MARKETINGCUTOFF
  55. , `LINKEDCATEGORIES` = @LINKEDCATEGORIES
  56. , `OVERRIDE_KWIKEE` = @OVERRIDE_KWIKEE
  57. , `FULFILLMENT_SORTING_ID` = @FULFILLMENT_SORTING_ID
  58. 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)))
  59.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement