>>>The index is Company_id+Employee_id+dtoc(testdate) on both PC's (length =24)
>>As Sergey suggested, DTOC() is suspect, You can use DTOS with CENTURY ON.
>
>Actually, you don't need
SET CENTURY ON for
DTOS(). Also, you can get the same return with
DTOC(date, 1), fwiw.
Thanks!
Imagination is more important than knowledge
