SQL Question - Complex ordering

[Bryan O'Neal]

Simple, it is a many many table that links resources located in
different tables and then my app tags the many remaining fields in that
table with specific information regarding how the resources are being
used. Several people have scolded my for repeated data, but really if
you have users in one table and the cars you can rent in a another table
and the types or rental terms in a third table, how do you rent a car
without putting the three keys into a fourth table?

Also, I do not use stored procedures because the criteria changes with
every run.  Think of it like going to the cable company and asking to
have a cable package put together where you choice from millions of
different channels based on your interest in the programs run on those
channels.  Every person will be different.

-----Original Message-----
From: plug-discuss-bounces at lists.plug.phoenix.az.us
[mailto:plug-discuss-bounces at lists.plug.phoenix.az.us] On Behalf Of
Randy Melder
Sent: Saturday, June 14, 2008 6:40 PM
To: Main PLUG discussion list
Subject: Re: SQL Question - Complex ordering

Why in the world would you insert data already existing in tables into
yet another table? Judging from your requirement, you are not changing
the data in any way, simply gathering it. So why have data in two
places? If you do, you're headed for un-reliability-ville. imho

If you REALLY need to create TEMP data for performance or whatever, make
sure it is in a stored procedure and not application logic.

; ) .randy
---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss