>>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.