中有这样的数据 City Number of office Total Offices Houston 620
Dallas 4 20 我想创建一个计算字段,其值的差异总办公室-(减去)和(办公室数量)。它应该看起来像这样(20 - (5+6+4)) =5 City Number of office Total Offices Difference(Calcul
(MS SQL)我正在尝试编写一个查询,该查询将捕获来自新办公室的前20笔贷款。我办公室的贷款号码是9位数(100100001)。前4位是办公室标识符,其余5位是发放的贷款总额。l.BorrowerLastName, Loan.LoanQA AS l
l.FundedDate BETWEEN '6/01/2014' AND '6/30/2014&