Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pete_N
Posting Yak Master
181 Posts |
 Posted - 2011-02-17 : 12:40:15
|
| I am importing several clients data into a new table. The new table has additional fields. what I would like to do is to compare a clients origional data against the same fields in the new table. Can anyone give me an example ieNew Tablefield: licence varcharfield: address varcharfield: billing carchar ( new field ) Client Tablefield: licence varcharfield: address varchareach cleint has their own unique licence numberthanks inadvance |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-17 : 13:14:41
|
| what do you mean by "comparing the clients original data against the same fields in the new table"? in order to see as if a client in old table exists in the new one with Same Info or to Update missing information of the new table columns with the data of the old table .. or to insert the clients from the old table to the new one if not exits etc etc etc .. ? Any how for all reasons you will need to Join both tables Cheers MIK |
 |
|
|
|
|
|
Data Checking