INSERT INTO tbl_PRD_#attributes.tableDomain#(LinkID, nutType, OwnerId, FSL_TableCode) SELECT p.sku_skuid AS linkID, '#attributes.catalogLevel#', #attributes.ownerid#, '#attributes.ownerType#' FROM tbl_IMPORT_Productdata p LEFT OUTER JOIN tbl_PRD_#attributes.tableDomain# n ON (n.linkid = p.sku_skuid AND n.ownerid = AND n.fsl_tableCode = AND n.nutType = ) WHERE eai_batchid = AND n.linkid IS NULL AND p.sku_skuid IS NOT NULL --SET ANSI_WARNINGS OFF; UPDATE nut SET comments = p.#_tblPrefix#comments, UnitMeasure = p.#_tblPrefix#UnitMeasure, UnitDescription = p.#_tblPrefix#UnitDescription, UnitPerSrv = p.#_tblPrefix#UnitPerSrv, WeightSrvGrams = p.#_tblPrefix#WeightSrvGrams, SrvPerContainer = p.#_tblPrefix#SrvPerContainer, Equv_Grams = p.#_tblPrefix#Equv_Grams, UnitPerSrv_Equv = p.#_tblPrefix#UnitPerSrv_Equv, UnitMeasure_Equv = p.#_tblPrefix#UnitMeasure_Equv, Ash = p.#_tblPrefix#Ash, Ash_equv = p.#_tblPrefix#Ash_equv, Biotin = p.#_tblPrefix#Biotin, Biotin_equv = p.#_tblPrefix#Biotin_equv, Calcium = p.#_tblPrefix#Calcium, Calcium_Type = p.#_tblPrefix#Calcium_Type, Calcium_equv = p.#_tblPrefix#Calcium_equv, Calcium_Type_Equv = p.#_tblPrefix#Calcium_Type_Equv, Calories = p.#_tblPrefix#Calories, Calories_Equv = p.#_tblPrefix#Calories_Equv, Carbs = p.#_tblPrefix#Carbs, Carbs_Equv = p.#_tblPrefix#Carbs_Equv, Carbs_PDV = p.#_tblPrefix#Carbs_PDV, Carbs_other = p.#_tblPrefix#Carbs_other, Carbs_other_Equv = p.#_tblPrefix#Carbs_other_Equv, Cholesterol = p.#_tblPrefix#Cholesterol, Cholesterol_Equv = p.#_tblPrefix#Cholesterol_Equv, Cholesterol_PDV = p.#_tblPrefix#Cholesterol_PDV, copper = p.#_tblPrefix#copper, copper_Equv = p.#_tblPrefix#copper_Equv, Energy = p.#_tblPrefix#Energy, Energy_Equv = p.#_tblPrefix#Energy_Equv, Fat = p.#_tblPrefix#Fat, Fat_Equv = p.#_tblPrefix#Fat_Equv, Fat_PDV = p.#_tblPrefix#Fat_PDV, Fat_Cal = p.#_tblPrefix#Fat_Cal, Fat_Cal_Equv = p.#_tblPrefix#Fat_Cal_Equv, Fiber = p.#_tblPrefix#Fiber, Fiber_Equv = p.#_tblPrefix#Fiber_Equv, Fiber_PDV = p.#_tblPrefix#Fiber_PDV, Fiber_Soluble = p.#_tblPrefix#Fiber_Soluble, Fiber_Soluble_Equv = p.#_tblPrefix#Fiber_Soluble_Equv, Fiber_Insoluble = p.#_tblPrefix#Fiber_Insoluble, Fiber_Insoluble_Equv = p.#_tblPrefix#Fiber_Insoluble_Equv, Folate = p.#_tblPrefix#Folate, Folate_Equv = p.#_tblPrefix#Folate_Equv, Iodine = p.#_tblPrefix#Iodine, Iodine_Equv = p.#_tblPrefix#Iodine_Equv, Iron = p.#_tblPrefix#Iron, Iron_Type = p.#_tblPrefix#Iron_Type, Iron_Equv = p.#_tblPrefix#Iron_Equv, Iron_Type_Equv = p.#_tblPrefix#Iron_Type_Equv, Magnesium = p.#_tblPrefix#Magnesium, Magnesium_Equv = p.#_tblPrefix#Magnesium_Equv, Moisture = p.#_tblPrefix#Moisture, Moisture_Equv = p.#_tblPrefix#Moisture_Equv, MonounsatFat = p.#_tblPrefix#MonounsatFat, MonounsatFat_Equv = p.#_tblPrefix#MonounsatFat_Equv, Niacin = p.#_tblPrefix#Niacin, Niacin_Equv = p.#_tblPrefix#Niacin_Equv, PantoAcid = p.#_tblPrefix#PantoAcid, PantoAcid_Equv = p.#_tblPrefix#PantoAcid_Equv , Phosphorous = p.#_tblPrefix#Phosphorous, Phosphorous_equv = p.#_tblPrefix#Phosphorous_equv, Potassium = p.#_tblPrefix#Potassium, Potassium_PDV = p.#_tblPrefix#Potassium_PDV, Potassium_Equv = p.#_tblPrefix#Potassium_Equv, PolyunsatFat = p.#_tblPrefix#PolyunsatFat, PolyunsatFat_Equv = p.#_tblPrefix#PolyunsatFat_Equv, Protein = p.#_tblPrefix#Protein, Protein_Equv = p.#_tblPrefix#Protein_Equv, Riboflavin = p.#_tblPrefix#Riboflavin, Riboflavin_Equv = p.#_tblPrefix#Riboflavin_Equv, SaturatedFat = p.#_tblPrefix#SaturatedFat, SaturatedFat_Equv = p.#_tblPrefix#SaturatedFat_Equv, SaturatedFat_PDV = p.#_tblPrefix#SaturatedFat_PDV, Sodium = p.#_tblPrefix#Sodium, Sodium_Equv = p.#_tblPrefix#Sodium_Equv, Sodium_PDV = p.#_tblPrefix#Sodium_PDV, Sugar = p.#_tblPrefix#Sugar, Sugar_Equv = p.#_tblPrefix#Sugar_Equv, SugarAlcohol = p.#_tblPrefix#SugarAlcohol, AddedSugar = p.#_tblPrefix#AddedSugars, AddedSugar_equv = p.#_tblPrefix#AddedSugars_equv, Thiamin = p.#_tblPrefix#Thiamin, Thiamin_Equv = p.#_tblPrefix#Thiamin_Equv, Transfat = p.#_tblPrefix#Transfat, Transfat_equv = p.#_tblPrefix#Transfat_equv, VitaminA = p.#_tblPrefix#VitaminA, VitaminA_Type = p.#_tblPrefix#VitaminA_Type, VitaminA_Equv = p.#_tblPrefix#VitaminA_Equv, VitaminA_type_Equv = p.#_tblPrefix#VitaminA_type_Equv, VitaminB6 = p.#_tblPrefix#VitaminB6, VitaminB6_Equv = p.#_tblPrefix#VitaminB6_Equv, VitaminB12 = p.#_tblPrefix#VitaminB12, VitaminB12_Equv = p.#_tblPrefix#VitaminB12_Equv, VitaminC = p.#_tblPrefix#VitaminC, VitaminC_Equv = p.#_tblPrefix#VitaminC_Equv, VitaminC_Type = p.#_tblPrefix#VitaminC_Type, VitaminC_Type_Equv = p.#_tblPrefix#VitaminC_Type_Equv, VitaminC_pdv = p.#_tblPrefix#VitaminC_pdv, VitaminD = p.#_tblPrefix#VitaminD, VitaminD_Equv = p.#_tblPrefix#VitaminD_Equv, VitaminE = p.#_tblPrefix#VitaminE, VitaminE_Equv = p.#_tblPrefix#VitaminE_Equv, VitaminK = p.#_tblPrefix#VitaminK, Zinc = p.#_tblPrefix#Zinc, Zinc_Equv = p.#_tblPrefix#Zinc_Equv, Calcium_pdv = p.#_tblPrefix#calcium_pdv, VitaminD_pdv = p.#_tblPrefix#vitaminD_pdv, Iron_pdv = p.#_tblPrefix#iron_pdv, Protein_pdv = p.#_tblPrefix#protein_pdv, AddedSugar_PDV = p.#_tblPrefix#addedSugars_PDV, VitaminA_PDV = p.#_tblPrefix#VitaminA_PDV, Calories_PDV = p.#_tblPrefix#Calories_PDV FROM tbl_PRD_#attributes.tableDomain# nut INNER JOIN tbl_IMPORT_ProductData p ON (nut.linkid = p.sku_skuid) WHERE p.eai_batchid = AND nut.OwnerID = AND nut.FSL_TableCode = AND nut.nutType = AND p.sku_skuid IS NOT NULL AND coalesce(p.sku_processAction,'') <> 'INACTIVE' --SET ANSI_WARNINGS OFF; UPDATE nut SET nut.Meat_MeatAlt_UnitPerSrv = p.Meat_MeatAlt_UnitPerSrv, nut.Meat_MeatAlt_UnitMeasure = p.Meat_MeatAlt_UnitMeasure, nut.FruitAlt_UnitPerSrv = p.FruitAlt_UnitPerSrv, nut.FruitAlt_UnitMeasure = p.FruitAlt_UnitMeasure, nut.Vegetable_UnitPerSrv = p.Vegetable_UnitPerSrv, nut.Vegetable_UnitMeasure = p.Vegetable_UnitMeasure, nut.Vegetable_Color = p.Vegetable_Color, nut.Grain_UnitPerSrv = p.Grain_UnitPerSrv, nut.Grain_UnitMeasure = p.Grain_UnitMeasure, nut.WholeGrain_UnitPerSrv = p.WholeGrain_UnitPerSrv, nut.WholeGrain_UnitMeasure = p.WholeGrain_UnitMeasure, nut.Milk_UnitPerSrv = p.Milk_UnitPerSrv, nut.Milk_UnitMeasure = p.Milk_UnitMeasure, nut.certificationNum = p.cn_certificationNum FROM tbl_PRD_#attributes.tableDomain# nut INNER JOIN tbl_IMPORT_ProductData p ON (nut.linkid = p.sku_skuid) WHERE p.eai_batchid = AND nut.OwnerID = AND nut.FSL_TableCode = AND nut.nutType = AND p.sku_skuid IS NOT NULL AND coalesce(p.sku_processAction,'') <> 'INACTIVE'