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
MAS 90 EDI workflow Email notifications EDI Software MAS 90 SQL Tools AdvancePro Efficiency Improvement Dynamics GP Recovery Sage Software football Peachtree Intuit Summit 2011 EDI MAS 90 SQL Utilities QuickBooks Enterprise Suite Security MAS 200 Support Payment Processing small business manufacturing exceeding tape size Windows 7 KnowledgeSync Attivo Full Value Support Dynamics GP Technical Support Microsoft CRM Affordable Accounting Sage ERP MAS 90 CutePDF PDF Writer ISO Consulting EDI for Dynamics Claude Cormane ACT! scanco Macola purging Event Manager email events Credit Card payment Year End Procedures for Macola ES Sage MAS 90 4.5 disaster recovery Progression Year End Accounting System Support aerospace suppliers QuickBooks upgrade Exact Consulting Software Consulting Will Breiholz BirdDog eCommerce Cost cutting QuickBooks data control Intuit Payments
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