DOS MAX to Exact MAX 5.5.4 – Recognize these?
Many companies are still running older versions of MAX even DOS MAX. We can convert and bring you up to the current level. Contact me and I can assist you. Vince Stefanetti Senior Consultant
Many companies are still running older versions of MAX even DOS MAX. We can convert and bring you up to the current level. Contact me and I can assist you. Vince Stefanetti Senior Consultant
Below is a recursive CTE that does a multi-level explosion for the current effective date. ;with mlBOM as ( select PARPRT_02, COMPRT_02 , QTYPER_02, EFFDTE_02 from Product_Structure WHERE PARPRT_02 = ‘ENTER PARENT PART’ union all — CTE recursion select n.PARPRT_02, n.COMPRT_02 , n.QTYPER_02, N.EFFDTE_02 from Product_Structure n inner join mlBOM c on c.COMPRT_02…
Web: http://www.max.exactamerica.com Training: https://training.exactamerica.com/ Portal: https://customers.exact.com
Then get: Msg 5834, Level 16, State 1, Line 1The affinity mask specified conflicts with the IO affinity mask specified. Use the override option to force this configuration. Use this to fix it: sp_configure ‘Allow Updates’, 0RECONFIGURE WITH OVERRIDE