Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to numeric. Expand / Collapse
Author
Message
Posted Saturday, May 28, 2011 4:51 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 20, 2011 1:23 AM
Points: 9, Visits: 33

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
Post #1116647
Posted Saturday, May 28, 2011 5:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:35 PM
Points: 7,161, Visits: 13,233
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
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #1116649
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse