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 - 2001-11-15 : 10:04:42
|
| Brandon writes "I am trying to clean up some tables and want to delete duplicate records. The records are not unique. Example.. I have a table called tests. Each record has a testid, studentid, and score.If the studentid is assigned to mulitple testid's then I want to delete all records but the last entered for the same studentid.I also want to know how to use nested stored procedures?Can stored procedures manipulate recordsets from other stored procedures.Thanks,Brandon" |
|
|
|
|
|
Deleting all records but last entered from a stored procedure