Posted by Analizer1 on 11/04/07 15:25

thanks for the insult...but i asked for some help..
on the best way to build indexes and query based on
columns in the table...that are not key columns

have a good one
later

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns99DDEFC24DF59Yazorman@127.0.0.1...
> 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

[Back to original message]