On Sat, 10 May 2008 12:40:10 -0400, rkc <rkc@[EMAIL PROTECTED]
>
wrote:
I fully agree, but figured that if they got to 2944 without realizing
this, we might have to chalk them up in the Lost Cause column.
-Tom.
<clip>
>
>You should cry anyway because what you have been given is not a
>database, it's a big pile of dung. Your current task is apparently
>to pile it higher.
>
> From the tiny bit of information in your post and what little I know
>about the insurance business I would say you should be looking at a
>single table with 4 columns to hold the whole pile.
>
>InsuranceRates(Age, Rate, PercentAbove, PercentBelow)
>
>Getting the information from your 2944 tables with 35 rows and a
>ridiculous number of columns into that one table could in fact be
scripted.
>
>That would make your life much easier and probably triple your currently
>available thumb twiddling time.
>
>The answer to your original question is yes, but I wouldn't want to show
>you how because it's a waste of time.
>
>
>
>
>
>
|
