Skip to Content
author's profile photo Former Member
Former Member

Conversion failed when converting the nvarchar value to data type int. (CINF)

Hi,

When executing stored procedure its showing the error [Microsoft][SQL Server Native Client 10.0][SQL Server]Conversion failed when converting the nvarchar value 'Customer Credit Period Exceeds' to data type int. (CINF)

if @object_type='17' and (@transaction_type in ('U'))

begin

declare @cnt2 int

set @cnt2=0

select @cnt2=Count(*) from ORDR P1 where P1.Docentry=@list_of_cols_val_tab_del and

(Select cast(DATEDIFF(DAY,isnull((select top 1 docdate from OINV where CardCode=P1.CardCode and DocStatus='O'

and (DocTotal-PaidSum)>1000 order by DocDate),getdate()),P1.DocDate)))>(10+Isnull((select ExtraDays from octg

where GroupNum=(select groupnum from OCRD where CardCode=P1.CardCode)),0))

begin

set @error='10001'

SET @error_message='Customer Credit Period Exceeds'

return @error_message

end

end

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Dec 29, 2014 at 01:41 AM

    Hi,

    If run above TN, I am not getting an error like your subject. Please check your TN.

    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded