将此ms访问代码转换为ms sql代码 [英] convert this ms access code to ms sql code

问题描述

选择tblBias_TP_RCU_AB.[主要有效成分]，Sum(IIf([范围内] ="X"，1,0))/Sum(IIf([材料] ="X"，1,0)) AS MAPE，tblBias_TP_RCU_AB.ChartDate INTO tmpBias_AI_TA_AB
来自tblBias_TP_RCU_AB
在哪里(((((tblBias_TP_RCU_AB.Material)="X")))
GROUP BY tblBias_TP_RCU_AB.[主要有效成分]，tblBias_TP_RCU_AB.ChartDate
拥有(((((tblBias_TP_RCU_AB.ChartDate)> DateAdd("m"，-25，[Forms]！[frmSwitch]！[Today])))
ORDER BY tblBias_TP_RCU_AB.[主要有效成分]，tblBias_TP_RCU_AB.ChartDate DESC;

SELECT tblBias_TP_RCU_AB.[Primary Active Ingredient], Sum(IIf([In Range]="X",1,0))/Sum(IIf([Material]="X",1,0)) AS MAPE, tblBias_TP_RCU_AB.ChartDate INTO tmpBias_AI_TA_AB
FROM tblBias_TP_RCU_AB
WHERE (((tblBias_TP_RCU_AB.Material)="X"))
GROUP BY tblBias_TP_RCU_AB.[Primary Active Ingredient], tblBias_TP_RCU_AB.ChartDate
HAVING (((tblBias_TP_RCU_AB.ChartDate)>DateAdd("m",-25,[Forms]![frmSwitch]![Today])))
ORDER BY tblBias_TP_RCU_AB.[Primary Active Ingredient], tblBias_TP_RCU_AB.ChartDate DESC;

推荐答案

您在错误的论坛中，但是您可能会发现此链接有用 http://www.databasejournal.com/features/msaccess/article.php/3705151/Converting-Access-Queries-to-SQL-Server.htm

you are in the wrong forums, however you may find this link useful http://www.databasejournal.com/features/msaccess/article.php/3705151/Converting-Access-Queries-to-SQL-Server.htm

这篇关于将此ms访问代码转换为ms sql代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！