The Attivo Group will get your system implemented - on time and within budget. Realize increased efficiencies, lower costs and improve profits. As trusted advisors for distributors, manufacturers and service providers, we will help you improve and automate your business processes.
Subscribe By Email
05-09-2013 / The Who, What, Why and When of Standard Costing
05-06-2013 / Effects of Barcoding Felt Well Beyond the Warehouse
04-29-2013 / Macola in the Cloud: A Match Made in Heaven
04-15-2013 / Understanding the Hidden Savings of Cloud ERP is Key
04-09-2013 / Behind the Numbers: Why Smart Money is on ERP
03-28-2013 / EDI - Taking Your ERP to the Next Level
03-11-2013 / Moving to the Cloud in 4 Easy Steps
03-06-2013 / Looking Past the Shop Floor to Improve Lead Times
02-26-2013 / In the World of Cloud Computing, Speed Can Kill
02-13-2013 / What Exactly is a "Dedicated Cloud"
02-07-2013 / 3 Revenue Pitfalls To Avoid When Moving to the Cloud
01-30-2013 / Where is ERP Heading for 2013?
01-24-2013 / Why Cloud Hosted ERP is Set to Take Off in 2013
restoring contacts ERP Support Exact Macola Enterprise Suite Website sales QuickBooks upgrade Benefits of ISO Certification Attivo Full Value Support software in the cloud Cost cutting Internal Controls with QuickBooks QuickBooks Serial/Lot Control ISO Consulting Hosted event management programming Macola Production Reporting address books Average Cost Acctivate EDI Software MAS 90 sage summit blackberry QuickBooks Security Light Manufacturing internet hosted contacts Business Consulting Ron Ploof Macola purging California State Board of Equalization Macola Manufacturing ISO consulant Accounting Year End Sage EES CPA and QuickBooks QuickBooks add on Macola Progression maintenance AS 9100 Certification jobBoss purge processes in Macola ERP systems Software ISO 9001:2008 MISys taxes BillQuick Software Rivalries BatchMaster Lead Times tape backups SQL Tools
Follow Len's Tweets...
Ever need to find all the places where a data element might appear in a database? You might need to make a change to the format of the column, or you just need to know where it is used in order to make a global update. This can be very time consuming if you try to do it the hard way. Here's a few easy to use scripts for you to run instead, using Macola Progression SQL and Macola ES (ERP systems) databases as examples: I. Macola Progression SQL database: a. Example: Find all tables in the data base that contain the data element "Prod_Cat" select TABLE_CATALOG, TABLE_NAME, COLUMN_NAME from dbname.information_schema.columns where column_name = 'prod_cat' order by table_name b. Example: Find all tables in the data base that contain a data element with the value of "Prod" somewhere in the element name. select TABLE_CATALOG, TABLE_NAME, COLUMN_NAME from dbname.information_schema.columns where column_name like '%prod %' order by table_name II. Macola ES Data base a. Example: Find columns with a specific name select TABLE_CATALOG, TABLE_NAME, COLUMN_NAME from information_schema.columns where column_name = 'prod_cat' order by table_name b. Example: Find all tables in the data base that contain a data element with the value of "Prod" somewhere in the element name. select TABLE_CATALOG, TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE,COLUMN_DEFAULT from information_schema.columns where column_name like '%prod%' order by table_name c. Example: Find columns from a specific table select TABLE_CATALOG, TABLE_NAME, COLUMN_NAME from information_schema.columns where table_name = 'cicmpy' order by table_name