SQL Question - Complex ordering

[Judd Pickell]

Your no 1 reason is also my reason for not being an expert. I haven't
done stored procedures enough now to even classify myself as useful
with them. Although everyone keeps saying it is something I should
learn, so I have been rearranging my servers with the plan to have an
oracle server I can play with stored procedures on. :)

Sincerely,
Judd Pickell

On Tue, Jun 17, 2008 at 2:37 PM, Bryan O'Neal
<BONeal at cornerstonehome.com> wrote:
> 1) I am not good with writing stored procedures.  (This is really the
> overwhelming reason. The rest are just excuses)
> 2) To build a black box I would need to build it to accept between 2 and
> 20 variables (Could be over a million, but no one has asked for anything
> containing more then a dozen, so 20 would be safe).
> 3) The SQL is easy once I figured out how to pass orders to an outer
> query using a temp table.
> 4) I may use ordering functions from 2 to 5 different tables, pull
> primary criteria data from 1 to 4 different tables and have literally
> thousands of relational points in those tables (and ID in table A can
> relate to up to 1K of points in table B and tables A, B, C, and D are
> growing fast.)  This seems complex for a black box.
>
> But mostly, or rather, entirely, the first reason is the trump card.  I
> have built very complex Black Boxes and relatively simple SQL engines in
> Java.  But I have a fairly good understanding of Java, and almost no
> understanding of IBM's PL language.  If you are good at stored
> procedures and are willing to work for beer and pizza I would absolutely
> love to get some practical training.  Especially when the query's start
> taking longer and longer to run.  And, of course, I will need to build
> the black box in something in probably less then a year so I can
> distribute the work out the original requestor via a dynamic menu driven
> builder.  But I do not have the time for that now.
>
> -----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 Judd
> Pickell
> Sent: Tuesday, June 17, 2008 1:37 PM
> To: Main PLUG discussion list
> Subject: Re: SQL Question - Complex ordering
>
>> 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.
>
> I just wanted to take a moment and follow this theory. I admit that I am
> not the greatest person at doing stored procedures, but the stored
> procedure is supposed to provide a programmable way to do all the things
> that you need to do. So you can modify your final output based on the
> criteria passed rather than being limited by the simple sql
> possibilities. Also I believe you can run stored procedures from within
> stored procedures, so you can basically build a controlled blackbox that
> based on the information coming in, can do many different things.
>
> Sincerely,
> Judd Pickell
> ---------------------------------------------------
> 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
>
> ---------------------------------------------------
> 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
>