ACCESS语句转换成SQL SERVER语句

[deansroom]

with dataf.hz1 do
  begin
    close;
    sql.Clear;
    sql.Add('TRANSFORM Sum(bt_table.b_bte) AS 总计 ');
    sql.Add('SELECT 0 as [序号],yh_table.Y_gzdw as [单位], yh_table.Y_xm as [姓名],yh_table.y_sfz as [身份证],Sum(bt_table.b_bte) AS [合计],yh_table.y_dabh as[备注]');
    sql.Add('FROM bt_table INNER JOIN (yh_table INNER JOIN js_table ON yh_table.y_id = js_table.y_id) ON bt_table.y_id = yh_table.y_id where yh_table.y_dabh<>" " and');
    SQL.Add('(bt_table.B_sqrq>=#' + FormatDateTime('yyyy-MM-dd' , DateTimePicker1.Date) + '# and bt_table.B_sqrq<=#' + FormatDateTime('yyyy-MM-dd', DateTimePicker2.date) + '#)');
    sql.Add('GROUP BY yh_table.Y_xm, yh_table.Y_gzdw, yh_table.y_sfz,yh_table.y_dabh  order by yh_table.y_dabh');
    sql.Add('PIVOT mid(yh_table.y_bz,2,5)');
    open;
  end;

转换成SQL SERVER语句

[hsmserver]

SQL没有TRANSFORM类似的功能
可以用CASE语句

[deansroom]

现在就是难到如何用CASE语句

[deansroom]

自己解决了！谢谢！