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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-22 : 10:32:19
|
| John writes "I need to populate a table C which should show the difference between two tables A and B. The tables A and B will be populated at different time intervals. There will be a flag in the Table 'C' which will indicate whether the record in C is the result of either 'Addition' or 'Deletion' or 'Modification'. In case of 'Addition' the records exist in B and not in A. In case of 'Deletion' the records exist in A and not in B. In case of 'Modification' the record exists in both the tables but there will be difference in Price. The table 'C' should have 'PriceMin' and 'PriceMax' column. We will be comparing the tables based on a column which cancontain duplicates or triplicates. This column will not allow nulls and is not unique. Please give me an idea about how to proceed. Your quick response is highly appreciated. Thank's alot.John." |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-05-22 : 10:32:19
|
| Is this a homework question? |
 |
|
|
|
|
|
Newbie