Monthly Archives: February 2014

Recursive CTE Multi-Level Explosion in Exact MAX

    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 … Continue reading

Posted in Uncategorized | Leave a comment

Exact MAX Manufacturing System Training is available

Web: http://www.max.exactamerica.com Training: https://training.exactamerica.com/ Portal: https://customers.exact.com

Posted in Uncategorized | Leave a comment

SQL 2005 Error Message when running DBCC CheckDB – Configuration option ‘allow updates’ changed from 0 to 0. Run the RECONFIGURE statement to install.

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 … Continue reading

Posted in Uncategorized | Leave a comment