To build company internal loss calculation paragraphs as other statements have built right

Internal quality loss=((target yield - the actual yield) * finished product price + (control defect rate - the actual defective rate) * defective base + base (control the rejection rate - the actual scrap rate) * waste) charge weight *

SQL statements below

Set internal quality loss=(convert (a decimal (18, 2), ISNULL ((convert (a decimal (18, 2), left (target yield and len (target yield) - 1))/100 - ISNULL (convert (a decimal (18, 2), left (the actual yield and len (the actual yield) - 1))/100, 0) the examination base + * (ISNULL ((convert (a decimal (18, 2), left (control defective rate, len (control defective rate) - 1))/100 - ISNULL (convert (a decimal (18, 2), left (the actual defective rate, len (the actual defective rate) - 1))/100, 0) * defective goods price + (ISNULL ((convert (a decimal (18, 2), left (control scrap, len rejection rate (control) - 1))/100 - ISNULL (convert (a decimal (18, 2), left (the actual scrap, len (the actual scrap rate) - 1))/100, 0) * waste base) * feeding weight)

The error code for
Message 102, level 15, state 1, process sp_k3_OutIn_All, line 158
'(' near a syntax error,

A great god, please help me correct the mistakes,

CodePudding user response:

Chinese parentheses (that is, the) in the error message, replaced with English

CodePudding user response:

Chinese braces me modify, test is an issue statement period of braces, I don't quite understand where need braces, where the bracket is superfluous, hope you teach a great god,

CodePudding user response:

Don't go wrong, it had much parenthesis

CodePudding user response:

SQL symbol should be in English, unless it is in the string data

CodePudding user response:

You this is the Chinese version of the SQL statement?