Post reply

Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to numeric.

  • May 28, 2011 at 4:51 am

    #236955

    Error

    Msg 8114, Level 16, State 5, Line 1

    Error converting data type varchar to numeric.

    Select A.CRT_Cod,A.CP_Nm,A.TSM,A.TSM_No,A.Lead,A.DSR_NM,A.DSR_no,A.Business_category as 'Trans_Typ', AMOUNT_AVAILABLE as 'Opening_Bal',

    SUM (A.ERC_TO_BE_BILD_2DAY) 'Bal_Loading_Target',

    SUM (case when MRP not in ('0','','Null') then A.MRP End ) 'Tran_Frm_DSR_to_Ret',

    Count (case when MRP not in ('0','','Null') then A.MRP End ) '#Ret'

    from BNG_BAL_TDAY A

    Left Outer JOIN Balance B on A.DSR_no = B.Donor_MDN

    Where A.Business_category = 'CDMA' and day(B.date)=day(getdate()-2) and B.BUSINESS_CATEGORY in ('CDMA')

    Group By A.CRT_Cod,A.CP_Nm,A.TSM,A.TSM_No,A.Lead,A.DSR_NM,A.DSR_no,A.Business_category,AMOUNT_AVAILABLE

    Thanks & Regards
    Sabari

  • May 28, 2011 at 5:03 am

    #1331335

    Errrmmm...

    What's the reason to repeat your question again and again even if you already have some answers???

    (for instance http://www.sqlservercentral.com/Forums/FindPost1116627.aspx)

    No replies please. Triple post.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply