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 |
|
anjali5
Posting Yak Master
121 Posts |
 Posted - 2014-11-25 : 00:25:09
|
Hi All,I have some duplicate records in my table, I need to make those records so they are not duplicate. There is a small dateTime field in that table, I want to add seconds to each row of that field in sequential order so that the record becomes distinct so for e.g if I have this in the field22-04-2014 10:00:0022-04-2014 10:00:0022-04-2014 10:00:0022-04-2014 10:00:00 so I want to make it like this so that all the duplicate rows becomes distinct22-04-2014 10:00:0122-04-2014 10:00:0222-04-2014 10:00:0322-04-2014 10:00:04 I am not sure if it is possible, but if it is then how can I achieve this. There are around 20 columns in this table or if there is any other suggestion to make these record distinct. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-25 : 06:46:28
|
| Why do you want to keep duplicate rows? |
 |
|
|
|
|
|
making duplicate records distinct