The 0E0 return value means that no rows were found. Are you positive that the corresponding TransactionID values exist in the table?

I'd like to know the schema for the table - the LongReadLen/LongTruncOK is an issue for TEXT or IMAGE columns, but are there any such columns in the table?

If you select only the TransactionID do you get different results?

Michael