VF statement accumulation 2

Date obtained:
Repl ls with substr (certid, 11,4) for Len (alltrim (certid) = 18
Brow
Repl ls with substr (certid, 9, 4) for Len (alltrim (certid) = 15
Modi stru
Repl all LS1 with left (LS, 2) + 'month' + right (LS, 2) + 'day'
Case statement:

Select B. servnumber,
Case when a. privid = 75900000062422 then''
When a. privid = 75900000062423 then''
When a. privid = 75900000062424 then''
When a. privid = 75900000062425 then''
End
From zjzw. cm_subs_privilege a join zjzw. cm_subs_subscriber B on A. subsid = B. subsid
Where a. privid in (7590021362422,7590042662423, 75900410624,7590042662425)
Compression statement:
Delete For substr (dhhm, 1, 1 )! = '1'
Add a record program to the table:
Set safe off
Sele
Use ls
Zap
Pack
Index on dhhm to S
Sele B
Use bb_hf_610
Go top
Do while. Not. EOF ()
AA = dhhm
Sele
Seek AA
If found ()
Repl hf_610 with B-> to_hf
Else
Appe Blank
Repl dhhm with AA
Repl hf_610 with B-> to_hf
Endif
Sele B
Skip

Enddo
Display directory:
Dir. * or dir
Case equivalent statement:
Repla all stopkey with ''for stopkey = '201312'
Repla all stopkey with ''for stopkey = '201312'
Repla all stopkey with ''for stopkey = '201312'
Repla all stopkey with ''for stopkey = '201312'
Repla all stopkey with ''for stopkey = '201312'

Eliminate zero situations during the summation process;
IIF (isnull (A. AMT), 0, A. AMT );
Multi-table join sum (same number ):
Select. dhhm, IIF (isnull (. to_hf), 0,. to_hf) + B. to_hf + C. to_hf + D. to_hf + E. to_hf + F. to_hf as avgconsume;
From bb_hf_703_bk a left join bb_hf_702_bk B on A. dhhm = B. dhhm left join bb_hf_701_bk C on A. dhhm = C. dhhm;
Left join bb_hf_612_bk D on A. dhhm = D. dhhm left join bb_hf_611 e on A. dhhm = E. dhhm left join bb_hf_610 F on A. dhhm = f. dhhm
The. DBF file is converted into a. txt file:
Appe from filename.txt SDF