String or binary data would be truncated Error?

[nomi2000]

In this portion of SP when i m running from SP i am getting
the above error but if i run the query from outside it runs perfect
Any Idea whats wrong?
Regards
Nouman

Declare @MySQL varchar(4000)
if UPPER(@DocType)='7501ABIENT'
begin

if @ImporterID=''
SELECT @MySQL='SELECT
0,
[CEC_ID],
[CEC_SH_ID],
[CEC_EntryNo],
[CEC_ChkDgt],
[CEC_FileNo],
[CEC_Process],
[CEC_TypeCode],
[SCDC_Desc],
[Status],
[SCC_PortEntry_ID],
[CEC_SecNo]
FROM
[dbo].[v_CustomsEntry_Select]
WHERE ltrim(rtrim([CEC_Process])) =''7501''
AND SCDC_Code=''Y'''
else
SELECT @MySQL='SELECT
0,
[CEC_ID],
[CEC_SH_ID],
[CEC_EntryNo],
[CEC_ChkDgt],
[CEC_FileNo],
[CEC_Process],
[CEC_TypeCode],
[SCDC_Desc],
[Status],
[SCC_PortEntry_ID],
[CEC_SecNo]
FROM
[dbo].[v_CustomsEntry_Select]
WHERE ltrim(rtrim([CEC_Process])) =''7501''
AND SCDC_Code=''Y''
AND SHC_Importer_ID='''+ @ImporterID +''''
--print @MySQL

INSERT INTO [dbo].[#TEMP_ABI_PROCESS]
exec (@MySql)

SELECT * from [dbo].[#TEMP_ABI_PROCESS]
end

Nouman Zaheer
Software Engineer
MSR

 

[eramgarden]

You normally get that error because you're trying to insert a value into a field that is larger than that field.

I'd say check the values you're inserting against the column lenght.