Question

Oracle数据库存储过程转化为SQL Server存储过程 在线等!!!

Orarle数据库存储过程如下：怎么转化为SQL Server存储过程！
create or replace procedure proc_getPayDetail
(
dtm varchar2,
resultset out sys_refcursor
)
as
begin
open resultset for
'select
emp.empid,
emp.ename,
emp.basepay,
case
when (select sum(hours*20) from tb_overtime where emptid=emp.id and
to_char(overtimedtm,''yyyy-mm'')=:dtm) is null then 0
else (select sum(hours*20) from tb_overtime where emptid=emp.id and
to_char(overtimedtm,''yyyy-mm'')=:dtm)
end overtimepay, -- 获得加班费用，规定加班每小时 20 元
case
when (select sum(days*case when personalleavetype=0 then 100 else 20 end) from
tb_personalleave where emptid=emp.id and to_char(personalleavedtm,''yyyy-mm'')=:dtm)
is null then 0
else (select sum(days*case when personalleavetype=0 then 100 else 20 end) from
tb_personalleave where emptid=emp.id and to_char(personalleavedtm,''yyyy-mm'')=:dtm)
end personalleavepay , -- 获得请假费用，规定，事假每天 100 元，病假每天 20 元
case
when (select sum(days*150) from tb_absence where emptid=emp.id and
to_char(absenceDtm,''yyyy-mm'')=:dtm) is null then 0
else (select sum(days*150) from tb_absence where emptid=emp.id and
to_char(absenceDtm,''yyyy-mm'')=:dtm)
end absencepay ---- 获得旷工扣除费用，规定旷工一天 150 元
from tb_emp emp' using dtm,dtm,dtm,dtm,dtm,dtm;
end;

Answer 1

这个过程的逻辑很简单，就是把员工在某个月所有的加班、请假、旷工的费用算出来；
你可以试着在网上找找Oracle转SQL server的工具，如果实在找不到的话，自己试着写也很简单的。
Sqlserver也有Case...when语法：
CASE result
WHEN '胜' THEN 1
WHEN '负' THEN 2
ELSE 0
END

Answer 2

重写，没好办法

追问

就是不会啊，存储过程这块没学好...