View Single Post
  #1  
Old 21st November 2002, 02:21
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,032
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Count Number of Records by Tables and Companies

Here I start my list of things To Do (Enhancement Requests) for the BaaN guys

The standard session count number of records by table - ttaad4222m000 takes only one company at a time.

We had our requirement to determine the table counts for a set of tables across all the companies.

Hence I made this sessions which gives the output to a Excel sheet.
Attached Images
File Type: jpg count-number-of-records-by-table-and-company.jpg (25.1 KB, 423 views)
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote