Re: sql query which has got 3 dynamic parameters

On Feb 24, 2:18 pm, Ed Murphy <emurph...@xxxxxxxxxxxx> wrote:
Vic wrote:
There are many databases like TestData6061, TestData606, TestData607

Okay, you referred to these as tables earlier; I assume you're right
now, and were wrong then.

under which there are tables like 'accounting', 'fundstructures',
'transaction' etc and each of these tables will have 'New', 'Update'
and 'Delete' as the record action. So basically idea is to find out
the coverage for 'accounting' -> 'AccountingParameters' for 'New',
'Update' and 'Delete' by mapping TestData6061/accounting with
accounting and AccountingParamter related rows in SchemaFields

Again, are you intending to keep unclean data out of the database, or
allow it into the database so that you can subsequently figure out how
you want to clean it up? If the former, then you're re-inventing a
square wheel (table constraints).

What does the full structure of 'accounting', 'fundstructures', etc.
look like? Do they contain a current set of entities, or a list of
changes to that set? (Your description of "record action" suggests
the latter.) Would it be possible to merge these into a single table
with 'accounting', 'fundstructures', etc. as values in an additional
column? If not, then how does your per-table logic adjust to account
for the different set of columns in each table?

what exactly you mean by unclean data? I am not sure about that.
basically accounting, fundstructures, transaction contain a set of
records which are of type 'New', Update and Delete. Basically I don't
really care about the columns that are present in those tables all I
am interested in is how many test cases (count) I have for say
'accounting'-> 'AccountingParameters' for 'New', 'Update' and Delete.
I want to know the same thing (New, Update and Delete count) for all
the object classes (i.e. accounting, calendar, transaction ...) and
Object Types (each object class would have a bunch of object types
like accounting-> accountingparameters, accounting-
financialaccounting, accounting->lockdownpool)
.

Relevant Pages

  • Re: Ahh, thats better...
    ... computerized accounting, ... accountants/bookkeepers click on that commit button, ... transaction history, so they'd know if an accountant is doing something ... most likely lifted from the accounting world by the database people. ...
    (rec.games.computer.ultima.dragons)
  • Re: double-entry bookkeeping unneeded?
    ... Like I said in my other reply, it comes down to a question of whether or not the entire system *needs* to know where the money comes from and if it *needs* a transaction to do that. ... The system knows it needs to return $6.29 to the customer to make the transaction balance. ... What I refer to as "payment" above should be understood to be objects and not just some generic account. ... Sure, you can lump that all into one big transaction and capture the essence of the accounting, but the business itself usually has a *large* number of uses for the underlying objects beyond accounting. ...
    (comp.object)
  • Re: Ahh, thats better...
    ... that term (transaction) is borrowed from accounting.... ... computerized accounting, ... accountants/bookkeepers click on that commit button, ... most likely lifted from the accounting world by the database people. ...
    (rec.games.computer.ultima.dragons)
  • Re: sql query which has got 3 dynamic parameters
    ... basically accounting, fundstructures, transaction contain a set of ... Object Types (each object class would have a bunch of object types ... Well, if you don't care, and want to explain to us what you are working, ...
    (comp.databases.ms-sqlserver)
  • Re: Ahh, thats better...
    ... computerized accounting, ... accountants/bookkeepers click on that commit button, ... transaction history, so they'd know if an accountant is doing something ... most likely lifted from the accounting world by the database people. ...
    (rec.games.computer.ultima.dragons)