Posted by Analizer1 on 11/03/07 17:55

hi all
i need to search a table for columns
i have to match data i recieve from a online transaction batch
example
in our system we send out
transactionno (unique)
Acctno (can be duplicated in transfile)
insuredacct (can be duplicated)
firstname (can be duplicated)
lastname (can be duplicated)
datofbirth (possible with the above duplicated)
transdate (not possible to be duplicated with the above)

we have a table with all completed transactions (few million)

I need to match the above to a transaction so i can report to the entity who
transmited the data to our company
the company we transmit to send back the above information..without the
transaction number

based on the above what is the best way to match to the correct row and how
should i build a index based on the above
thank you lots
analizer1

what is the best wa

[Back to original message]