|
|
Posted by Erland Sommarskog on 11/03/07 22:26
Analizer1 (vettes_n_jets@yahoo.com) writes:
> 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
I think you should take that again, but slower this time and with some
punctuation and capitals in the beginning of sentences. And most of all
clearer. At this point, I'm not really sure what is going on. But I get
an impression that there is something ugly going on if you sent out a
unique id, but do not get in back.
Anyway, a standard recommendation is that you include:
o CREATE TABLE statment(s) for your table(s).
o INSERT statements with sample data.
o The desired result given the sample.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|