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 |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2006-10-03 : 15:48:55
|
| Guys,I am dealing with following Duplicate sets (I have 40000 of them) for each value of BP we have different sets of seq, type. To distinguish the duplicate set I want to populate a column called subid with no if times the duplicate set occurs for each value of BP. Note that table has rows ordered by BPBP SEQ TYPE SUBID_____________________________100 1 1 1100 2 1 1100 3 3 1------ SET ONE --------------100 1 1 2100 2 1 2100 3 3 2------ SET TWO --------------200 1 1 1200 2 3 1------ SET ONE --------------200 1 1 2200 2 3 2------ SET TWO ------------any suggestions/inputs would helpThanks |
|
|
|
|
|
Identifying duplicate sets