dim rec as adodb.recortset
set rec=new adodb.recordset
rec.open "Select IsNull(Salary14,0)/IsNull(Salary20,0)*IsNull(Days,0)*(CASE WHEN IsNull(Salary2,0)=0 THEN 1 ELSE IsNull(Salary2,0) END) From V_SA_SalaryDetail Where (MonthName='2002-11') AND (EmpID=100009)",cnCloud
set rec=new adodb.recordset
rec.open "Select IsNull(Salary14,0)/IsNull(Salary20,0)*IsNull(Days,0)*(CASE WHEN IsNull(Salary2,0)=0 THEN 1 ELSE IsNull(Salary2,0) END) From V_SA_SalaryDetail Where (MonthName='2002-11') AND (EmpID=100009)",cnCloud
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货