How to Combine Two Tables 1

[HisMightiness]

I am new to SQL Server development, but I use the automated features in Enterprise Manager a lot.

I have a table with a specific format already existing in a SQL Server 2000 database. This is generated once a day from a flat file received from an outside vendor. I am now receiving a similar flat file from another vendor which is nearly identical, but with two differences.

First, the new flat file is missing two columns (not critical data).

Next, there is one column that is out of order in comparison to the other flat file (aside from the 2 missing columns).

I need a generic example of how to remove specific records from a table and add these new ones (from the new flat file) through the SQL Server. My intention is to have a job run at a specific time through the SQL Server.

Any help is appreciated. If you know of a good tutorial or something out there, I would be more than happy to check it out. Thank you so much for your help!

Will

http://www.ServiceRank.com/

 

[Catadmin]

Books Online is a wonderful resource. You should probably refer to the following items in the "Index" portion of BOL:

Delete, Insert, Update, Views, Select, and Where.

The above are essential parts of the basic T-SQL Statements and you should know them if you intend to do anything with SQL Server. Additionally, SQL Sister has posted a FAQ with recommended books on SQL Faq183-3324. Check it out. It has pretty good documentation references.



Catadmin - MCDBA, MCSA
"Just because I'm paranoid doesn't mean the universe *isn't* out to get me!"

 

[HisMightiness]

I already know how to query. I am trying to permanently combine the data of both tables, not perform a JOIN query. (Or did I miss the point?)

Will

http://www.ServiceRank.com/

 

[dbomrrsm]

look at using DTS - you can select a text file source (then specify the file) then a SQL Server connection then do a transform data task between the two then double click the line created by the transform data task.

Select the destination as the existing sql server table then go to transformations where you can map which field from the source go into which field in the destination.



[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[HisMightiness]

WOW! I never really used the DTS portion of Enterprise Manager before. It seemed confusing at first until I had your step-by-step starting point. Thanks DBomrrsm!

Will

http://www.ServiceRank.com/

 

[dbomrrsm]

Your most welcome

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]