Skip to Content
avatar image
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

  • Get RSS Feed

1 Answer

  • 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