flaniganmj
Technical User
There is an existing global temp table that (for arguement sake) cannot be changed. It has many fields, and the combination of two of them should prove represent a unique row. However, it is not inforced. So, occasionally, something like below may 'pop' in:
[tt]
Field 1 Field2
------- ------
1 2
1 3
1 4
1 4
[/tt]
I need one of the last two records removed. So the recordset would look like this:
[tt]
Field 1 Field2
------- ------
1 2
1 3
1 4
[/tt]
I cannot add an identity field. The other attributes in the table are not relavent; so, I don't care which one is removed. This seems like it should be quite easy, but I have continued to have problems with it.
Regards,
mjf