INSERT INTO [KLL_Cust].[dbo].[KLLStyleMasterException] ( [pkey] , [season] , [Style] , [lbl_code] , [dimension] , [Date] ) SELECT DISTINCT L.pkey , L.season , RTRIM(L.style) Style , lbl_code , L.dimension , GetDate() Datetime FROM zzxscolr L LEFT OUTER JOIN ( SELECT DISTINCT pkey , style , dimension FROM zzcordrd WHERE total_qty <> 0 ) P ON P.style = L.style AND P.dimension = L.dimension WHERE L.lbl_code <> '' AND L.style NOT IN ( SELECT style FROM zzxscolr N WHERE L.style = N.style AND L.dimension = N.dimension AND L.color_code = N.color_code AND N.lbl_code = '' ) AND L.season <> 'ANY' AND division = 'KLL' AND season > '20171' AND P.style IS NOT NULL END;
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.