Posted by Shwetabh on 03/08/06 13:34

Hi,
Well I cant really do anything about the design for table2 because that
is the way the client wants it to be.

As far as table3 goes, I wanted to check the possiblility of appending
the
records of all the tables into a single table and check the performance
and
efficiency. I understand that table3 is a poor database design
but the main motivation for doing this is to check the reaction of the
application
which will using such database.

Also, till now, I have converted DBASE database into SQL database using

OPENROWSET to import the data, I was wondering if the same database
can be entered into a new table which can hold the data from all
tables.

Any ideas?

Regards,
Shwetabh


P.S: If you want I can mail you the code I have written in VB for this
purpose.

• Next in forum: Re: how to write one stored procedure for a (same column )present in 20 tables
• Prev in forum: Re: how to write one stored procedure for a (same column )present in 20 tables
• Thread view: Re: Appending tables

[Reply to this message]