Advertisement
penright

Untitled

Jul 31st, 2023
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.80 KB | None | 0 0
  1. UPDATE `xxxxx`.`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.  
  59. WHERE ((`COMMON_ITEM_NUMBER` = @Original_COMMON_ITEM_NUMBER)
  60. AND (`IRIS_ITEM_NUMBER` = @Original_IRIS_ITEM_NUMBER) AND ((@IsNull_UPC = 1 AND `UPC` IS NULL)
  61. OR (`UPC` = @Original_UPC)) AND ((@IsNull_ONLINE_MARKDOWN_DESCRIPTION_NOAUTOUPDATE = 1 AND `ONLINE_MARKDOWN_DESCRIPTION_NOAUTOUPDATE` IS NULL)
  62. OR (`ONLINE_MARKDOWN_DESCRIPTION_NOAUTOUPDATE` = @Original_ONLINE_MARKDOWN_DESCRIPTION_NOAUTOUPDATE)) AND ((@IsNull_CALC_SIZE = 1 AND `CALC_SIZE` IS NULL)
  63. OR (`CALC_SIZE` = @Original_CALC_SIZE)) AND ((@IsNull_MIN_SIZE = 1 AND `MIN_SIZE` IS NULL)
  64. OR (`MIN_SIZE` = @Original_MIN_SIZE)) AND ((@IsNull_MAX_SIZE = 1 AND `MAX_SIZE` IS NULL)
  65. 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)
  66. OR (`UOM` = @Original_UOM)) AND ((@IsNull_CHAINWIDEITEMOFF = 1 AND `CHAINWIDEITEMOFF` IS NULL)
  67. OR (`CHAINWIDEITEMOFF` = @Original_CHAINWIDEITEMOFF)) AND ((@IsNull_PACKAGE = 1 AND `PACKAGE` IS NULL)
  68. OR (`PACKAGE` = @Original_PACKAGE)) AND ((@IsNull_PACK_INFO = 1 AND `PACK_INFO` IS NULL)
  69. OR (`PACK_INFO` = @Original_PACK_INFO)) AND ((@IsNull_SERVINGSPERCONTAINER_VALUES = 1 AND `SERVINGSPERCONTAINER_VALUES` IS NULL)
  70. OR (`SERVINGSPERCONTAINER_VALUES` = @Original_SERVINGSPERCONTAINER_VALUES)) AND ((@IsNull_SERVINGSIZE_VALUES = 1 AND `SERVINGSIZE_VALUES` IS NULL)
  71. OR (`SERVINGSIZE_VALUES` = @Original_SERVINGSIZE_VALUES)) AND ((@IsNull_CALORIES_VALUES = 1 AND `CALORIES_VALUES` IS NULL)
  72. OR (`CALORIES_VALUES` = @Original_CALORIES_VALUES)) AND ((@IsNull_TOTALFAT_VALUES = 1 AND `TOTALFAT_VALUES` IS NULL)
  73. OR (`TOTALFAT_VALUES` = @Original_TOTALFAT_VALUES)) AND ((@IsNull_SATURATEDFAT_VALUES = 1 AND `SATURATEDFAT_VALUES` IS NULL)
  74. OR (`SATURATEDFAT_VALUES` = @Original_SATURATEDFAT_VALUES)) AND ((@IsNull_TRANSFAT_VALUES = 1 AND `TRANSFAT_VALUES` IS NULL)
  75. OR (`TRANSFAT_VALUES` = @Original_TRANSFAT_VALUES)) AND ((@IsNull_CHOLESTEROL_VALUES = 1 AND `CHOLESTEROL_VALUES` IS NULL)
  76. OR (`CHOLESTEROL_VALUES` = @Original_CHOLESTEROL_VALUES)) AND ((@IsNull_SODIUM_VALUES = 1 AND `SODIUM_VALUES` IS NULL)
  77. OR (`SODIUM_VALUES` = @Original_SODIUM_VALUES)) AND ((@IsNull_TOTALCARBOHYDRATE_VALUES = 1 AND `TOTALCARBOHYDRATE_VALUES` IS NULL)
  78. OR (`TOTALCARBOHYDRATE_VALUES` = @Original_TOTALCARBOHYDRATE_VALUES)) AND ((@IsNull_DIETARYFIBER_VALUES = 1 AND `DIETARYFIBER_VALUES` IS NULL)
  79. OR (`DIETARYFIBER_VALUES` = @Original_DIETARYFIBER_VALUES)) AND ((@IsNull_TOTALSUGARS_VALUES = 1 AND `TOTALSUGARS_VALUES` IS NULL)
  80. OR (`TOTALSUGARS_VALUES` = @Original_TOTALSUGARS_VALUES)) AND ((@IsNull_ADDEDSUGARS_VALUES = 1 AND `ADDEDSUGARS_VALUES` IS NULL)
  81. OR (`ADDEDSUGARS_VALUES` = @Original_ADDEDSUGARS_VALUES)) AND ((@IsNull_PROTEIN_VALUES = 1 AND `PROTEIN_VALUES` IS NULL)
  82. OR (`PROTEIN_VALUES` = @Original_PROTEIN_VALUES)) AND ((@IsNull_VITAMIND_VALUES = 1 AND `VITAMIND_VALUES` IS NULL)
  83. OR (`VITAMIND_VALUES` = @Original_VITAMIND_VALUES)) AND ((@IsNull_CALCIUM_VALUES = 1 AND `CALCIUM_VALUES` IS NULL)
  84. OR (`CALCIUM_VALUES` = @Original_CALCIUM_VALUES)) AND ((@IsNull_POTASSIUM_VALUES = 1 AND `POTASSIUM_VALUES` IS NULL)
  85. OR (`POTASSIUM_VALUES` = @Original_POTASSIUM_VALUES)) AND ((@IsNull_IRON_VALUES = 1 AND `IRON_VALUES` IS NULL)
  86. OR (`IRON_VALUES` = @Original_IRON_VALUES)) AND ((@IsNull_ADDEDSUGARS_PERCENT = 1 AND `ADDEDSUGARS_PERCENT` IS NULL)
  87. OR (`ADDEDSUGARS_PERCENT` = @Original_ADDEDSUGARS_PERCENT)) AND ((@IsNull_SERVINGSIZE_PERCENT = 1 AND `SERVINGSIZE_PERCENT` IS NULL)
  88. OR (`SERVINGSIZE_PERCENT` = @Original_SERVINGSIZE_PERCENT)) AND ((@IsNull_CALORIES_PERCENT = 1 AND `CALORIES_PERCENT` IS NULL)
  89. OR (`CALORIES_PERCENT` = @Original_CALORIES_PERCENT)) AND ((@IsNull_TOTALFAT_PERCENT = 1 AND `TOTALFAT_PERCENT` IS NULL)
  90. OR (`TOTALFAT_PERCENT` = @Original_TOTALFAT_PERCENT)) AND ((@IsNull_SATURATEDFAT_PERCENT = 1 AND `SATURATEDFAT_PERCENT` IS NULL)
  91. OR (`SATURATEDFAT_PERCENT` = @Original_SATURATEDFAT_PERCENT)) AND ((@IsNull_CHOLESTEROL_PERCENT = 1 AND `CHOLESTEROL_PERCENT` IS NULL)
  92. OR (`CHOLESTEROL_PERCENT` = @Original_CHOLESTEROL_PERCENT)) AND ((@IsNull_SODIUM_PERCENT = 1 AND `SODIUM_PERCENT` IS NULL)
  93. OR (`SODIUM_PERCENT` = @Original_SODIUM_PERCENT)) AND ((@IsNull_TOTALCARBOHYDRATE_PERCENT = 1 AND `TOTALCARBOHYDRATE_PERCENT` IS NULL)
  94. OR (`TOTALCARBOHYDRATE_PERCENT` = @Original_TOTALCARBOHYDRATE_PERCENT)) AND ((@IsNull_DIETARYFIBER_PERCENT = 1 AND `DIETARYFIBER_PERCENT` IS NULL)
  95. OR (`DIETARYFIBER_PERCENT` = @Original_DIETARYFIBER_PERCENT)) AND ((@IsNull_VITAMIND_PERCENT = 1 AND `VITAMIND_PERCENT` IS NULL)
  96. OR (`VITAMIND_PERCENT` = @Original_VITAMIND_PERCENT)) AND ((@IsNull_CALCIUM_PERCENT = 1 AND `CALCIUM_PERCENT` IS NULL)
  97. OR (`CALCIUM_PERCENT` = @Original_CALCIUM_PERCENT)) AND ((@IsNull_POTASSIUM_PERCENT = 1 AND `POTASSIUM_PERCENT` IS NULL)
  98. OR (`POTASSIUM_PERCENT` = @Original_POTASSIUM_PERCENT)) AND ((@IsNull_IRON_PERCENT = 1 AND `IRON_PERCENT` IS NULL)
  99. OR (`IRON_PERCENT` = @Original_IRON_PERCENT)) AND ((@IsNull_IMAGES_SOURCE = 1 AND `IMAGES_SOURCE` IS NULL)
  100. OR (`IMAGES_SOURCE` = @Original_IMAGES_SOURCE)) AND ((@IsNull_MARKETINGCUTOFF = 1 AND `MARKETINGCUTOFF` IS NULL)
  101. OR (`MARKETINGCUTOFF` = @Original_MARKETINGCUTOFF)) AND ((@IsNull_OVERRIDE_KWIKEE = 1 AND `OVERRIDE_KWIKEE` IS NULL)
  102. OR (`OVERRIDE_KWIKEE` = @Original_OVERRIDE_KWIKEE)) AND ((@IsNull_FULFILLMENT_SORTING_ID = 1 AND `FULFILLMENT_SORTING_ID` IS NULL)
  103. OR (`FULFILLMENT_SORTING_ID` = @Original_FULFILLMENT_SORTING_ID)))
  104.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement