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 |
|
petervi
Starting Member
1 Post |
 Posted - 2005-05-16 : 17:17:00
|
| hi,i have to create a stored procedure which searches the sales fact table which has duplicate rows on salesuniqueid field, which should not be duplicated. the routine should check all fields in fact table to determine which field(s) are different between the duplicated records. then there should be a rountine to run to delete the non-valid duplicated records(i.e which records have fields with sids(dimension tables) where currenentrec_ind=N), leaving only one of the records in the sales fact table.thanks,peter |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2005-05-17 : 07:10:14
|
| What day does the professor want this by? and which class?*need more coffee* |
 |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-05-17 : 07:54:07
|
| What Don is saying petervi is we dont answer homework questions.JimUsers <> Logic |
|
|
|
|
|
|
How to delete duplicate records from fact table