got you all. will further discuss with my team leader.

Thank you.

Yes, i found the SET ANSI_WARNINGS option might be related to te result i get. So, i try to turn on and off the option and both also give me...

Please allow me to further explain my concern here:

The SQL script i posted here is extracted from an existing stored procedure of my system using SQL2000 and it is...

Thanks for the reply.

I understand that temp table is define as 25, and the actual max length for the data is 40. So the 'Truncate ... ' error return in...