Im trying to figure out the best way and/or fastest way to Match some data
comming in....example below
the below is all the incomming information i recieve to match to a row in
our system, we do send out a TransactionId but reports comming
back in do not reflect this id.. so i have to match the data. Matching is
pretty easy enough, but only been working with SqlServer about a Year now
and the existing system well Sucks on matching, so i want your advice and
the best way and fastest way to match up rows
with a high percentage..

when building a Index for the below , does sql store the data being indexed
in separate columns
or are the Columns being indexed concatenated via the column order being
sorted

all you input i very welcome
tks
Mike


--not a key column
accountNo account of incomming partners customer
FirstName account holder first name
last name account holder last name
dateOfTrans account holder Transaction date