Re: Generic data types in SQL Server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

John,
these are not 'business rules'...these are attributes of customer and
would most effectively be stored as separate attributes.....overtyping
fields based on other fields is something we did in languages like
cobol to save space and coding......not really something we should do
in an environment where the end user is supposed to query the data.

Best Regards
Peter Nolan
www.peternolan.com

.

Relevant Pages

  • Re: Need to match two field of data before updating table
    ... That's great thanks John, I would prefer to go with the choice of putting ... I would append the records from each excel sheet to a separate ... TblCustomerList would not have any of the survey data in it ... and would only consist of information about the customer CustomerId, Plant, ...
    (microsoft.public.access.queries)
  • Re: Application logic and Business logic
    ... Vijay Singh wrote: ... > application logic and business logic should be kept separate from ... Whats the difference between application logic and business ... code that may not even be required or wanted by the customer, ...
    (comp.object)
  • Re: What problems are people in the MV world trying to solve
    ... This is a combination of business and technical. ... system is centered around a customer account and the ID assigned to it so ... contact files by account ID. ... The sales analysis system only ...
    (comp.databases.pick)
  • Re: My Frustrations
    ... Again, this is not an issue of communication, or geeks versus business men. ... This is not an issue of proving or demonstrating the quality of ones self or service. ... This is an issue of enabling the customer to make the right decision. ... landing the customer in a very poor security state, ...
    (Pen-Test)
  • Re: Ms Access 2003
    ... "I'd like to pay less than $150 for this project." ... One would expect that for such a low price as ... though there's no add-ons to increase profits, increase the customer base, ... a small business which employs five consultants. ...
    (comp.databases.ms-access)