T-SQL XML Path Solution to BOM Notes to a Single Row

SELECT SS.PARPRT_02, SS.COMPRT_02, SS.EFFDTE_02 , SS.QTYPER_02, (SELECT ‘~’ + US.NOTES_61 FROM Windows_Notes US WHERE US.PRTNUM_61 = SS.PARPRT_02 AND US.COMPRT_61 = SS.COMPRT_02 AND US.EFFDTE_61 = SS.EFFDTE_02 AND US.TYPE_61 = ‘BM’ FOR XML PATH(”) ) [BOM/NOTES] FROM Product_Structure SS WHERE PARPRT_02 <> ” GROUP BY SS.PARPRT_02, SS.COMPRT_02, SS.EFFDTE_02, SS.QTYPER_02 ORDER BY 1, 2 Vincent Stefanetti Senior Consultant…

Read More

Clear GP Users

delete from DYNAMICS..ACTIVITY where USERID not in (select loginame from master..sysprocesses) delete from tempdb..DEX_SESSION where session_id not in (select SQLSESID from DYNAMICS..ACTIVITY) delete from tempdb..DEX_LOCK where session_id not in (select SQLSESID from DYNAMICS..ACTIVITY) delete from DYNAMICS..SY00800 where USERID not in (select USERID from DYNAMICS..ACTIVITY) delete from DYNAMICS..SY00801 where USERID not in (select USERID from DYNAMICS..ACTIVITY)

Read More

Announcing the release of Max 5.5.9

Subject: Preview – Announcing the release of Max 5.5.9 ECi Software is please to announce the release of Max 5.5.9, batch 4775. Max 5.5.9 is available for download! Hi Friend, ECi is pleased to announce the release of Max 5.5.9, batch 4775. This release includes: Over 75 defect fixes Compatibility with QB Enterprise 2019 Compatibility…

Read More

NET1 Payment Processing Solution Introduces New Multi-location Functionality

Reporting and security for enterprises with multiple locations can be handled through one point of access Fort Worth, TX—Wednesday, June 12, 2019 ECi Software Solutions, a leader in cloud-based business management solutions, today announced multi-location functionality for the NET1® Payment Processing Solution, an internet-based system that fully integrates with the Advantage®, DDMS®, DDMSPLUS®, e-automate®, M1®,…

Read More