Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users
insert into sku_master select SKU = convert(char(15),I.ITEMNMBR), Class = '01', Env_Code = ' ', Storage_Velocity_Code = ' ', CC_Velocity_Code = ' ', Description1 = convert(char(50),I.ITEMDESC), Description2 = ' ', Unit_Desc = ' ', Bulk_Desc = ' ', Bulk_Qty = 0, Bulk_Pick_Flag = 'N', Bulk_Loc_Type = ' ', Unit_Loc_Type = ' ', Length = 0, Width = 0, Height = 0, Cube = 0, Weight = convert(float,I.ITEMSHWT), Serial_Track = 'N', Lot_Track = 'N', Exp_Date_Track = 'N', Mfg_Date_Track = 'N', High_Qty = 0, Tie_Qty = 0, Preemptive_Putaway_Flag = 'N', Shippable_Unit = 'N', Cost = convert(float,I.CURRCOST), Substitute_SKU = convert(char(15),I.ALTITEM1), New_SKU = 'N', Age_Control = 'N', Rule_ID = 'DEFLT', Preferred_Zone = ' ', PickGen_Rule = 'RULE1', Update_Date = getdate(), Update_User_ID = 'INIT', Update_PID = 'DTS' from GP9TST.KELEG.dbo.IV00101 I JOIN GP9TST.KELEG.dbo.IV00102 N on I.ITEMNMBR = N.ITEMNMBR where convert(char(15),I.ITEMNMBR) not in ( select SKU from sku_master) and N.LOCNCODE = 'MEMPHIS'
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.