I have a company with DELPHI cashier system, a problem now, hope you can help me solve the great god,




How to solve?

CodePudding user response:

How the code not to go up and try again

CodePudding user response:

Select
B.W JZSHID,
B.L XRMC,
B.Z H,
COUNT (B.L XRMC) SL,
The SUM (round (a. SJE_17 + a. SJE_13 + a. SJE_QT + A.Z ZSJE_17 + A.Z ZSJE_13 + A.Z ZSJE_QT - isnull (A.K KJE_FYHK, 0), (2)) SFJE

The from JSD A,
WLDW B,
HT_LY C
Where
Aleem walji LDW=biggest ODE AND
A.H TH=c. TH AND
A.H TH<90000000 AND
A. SFKD_JLBH IS NULL
Group by B.W JZSHID,
B.L XRMC,
B.Z H
Having the SUM (round (a. SJE_17 + a. SJE_13 + a. SJE_QT + A.Z ZSJE_17 + A.Z ZSJE_13 + A.Z ZSJE_QT - isnull (A.K KJE_FYHK, 0), (2)) & gt; @ var1
The order by B.W JZSHID

CodePudding user response:

Select
B.W JZSHID,
B.L XRMC,
B.Z H,
COUNT (B.L XRMC) SL,
The SUM (round (a. SJE_17 + a. SJE_13 + a. SJE_QT + A.Z ZSJE_17 + A.Z ZSJE_13 + A.Z ZSJE_QT - isnull (A.K KJE_FYHK, 0), (2)) SFJE

The from JSD A,
WLDW B,
HT_LY C
Where
Aleem walji LDW=biggest ODE AND
A.H TH=c. TH AND
A.H TH<90000000 AND
A. SFKD_JLBH IS NULL
Group by B.W JZSHID,
B.L XRMC,
B.Z H
Having the SUM (round (a. SJE_17 + a. SJE_13 + a. SJE_QT + A.Z ZSJE_17 + A.Z ZSJE_13 + A.Z ZSJE_QT - isnull (A.K KJE_FYHK, 0), (2)) & gt; @ var1
The order by B.W JZSHID

CodePudding user response:

The @ var1 is defined as a string, use char (39) + var1 + char (39) to spell SQL statements can be,