The Query is running but I expect 6400 records without error. But here i ran the query 200 Records came with Arithmetic overflow error converting varchar to data type numeric Error After i ran the same query 600 records are came with error again i ran the query 0 records with the error.

so what is the problem with the query are SQL Server

Sql Server Version is SQL Server 2005 EE.

-- Ragu