Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
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'
|How to set UNMASK permission only to only one table in SQL Server 2016 ?||11||75|
|T-SQL: Episode III - Revenge of The Dude||24||52|
|cannot connect to sqlserver||8||25|
|SSIS with VPN COnnection||2||70|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!