<laskowski@gmail.com> wrote in message
news:1128215882.557186.321000@z14g2000cwz.googlegroups.com...
>I am importing old DBF's into SQL, however I have an issue. There
> are 400 tables, but the primary keys are table names. For example,
> there is one main table "a" which has a column named Book, the rows
> in this column link to other tables by their table name. So, the book
> column has a row with an integer of 1 and the table which it joins with
> is named "1".
>
> Any ideas on how to de-normalize these and pump them into SQL using
> TSQL?
>
>
> CREATE TABLE a
> (
> Book int,
> Data varchar(20)
> )
>
> CREATE TABLE 1
> (
> Data varchar(20)
> MoreData varchar(20)
>

>>Any ideas on how to de-normalize these and pump them into SQL using TSQL? <<

"--CELKO--" <jcelko212@earthlink.net> wrote in message
news:1128217848.162624.192720@g49g2000cwa.googlegroups.com...
> WHY DID ANYONE A SCHEMA LIKE THIS??? You have mixed data and meta-data
> in total violation of **fundamental** rules?? Run overthis person in
> the parking lot before they kill children.
>
>>>Any ideas on how to de-normalize these and pump them into SQL using TSQL?
>>><<
>
> Need you really mean "denormalize"? This is already total crap, there
> is no way to make it worse.
>

"laskowski@gmail.com" wrote:

> Joe,
>
> Knock off the flaming! This application was written in Clipper back in
> 1990. A year in which I was still wearing diapers. Instead of
> preaching from your ANSI standard high horse, step back and offer an
> intelligent solution.
>