sqlserver将查询结果作为参数传入存储过程

Question

存储过程 ClientCredit 只需一个参数，然后我需要将
select distinct f5 from tableA where f2>='20140101' and f119<>'1' and f58>0 and f100<>'Y' and f4='1' and f20='6' 的查询结果作为参数传入存储过程,该怎么实现？急急急

Answer 1

create or replace callproc
as
begin
for v (select distinct f5 from tableA where f2>='20140101' and f119<>'1' and f58>0 and f100<>'Y' and f4='1' and f20='6') loop
ClientCredit(v.f5);
end;追问

报错啊？怎么搞的。

追答

上面是oracle语法

下面是sqlserver语法：
create callproc
CREATE CALLPROC
as
declare @v_f5 nvarchar(20)
declare cur cursor for select distinct f5 from tableA where f2>='20140101' and f119'1' and f58>0 and f100'Y' and f4='1' and f20='6')
OPEN CUR
FETCH NEXT FROM cur into @v_f5
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ClientCredit(@v_f5);
FETCH NEXT FROM cur into @v_f5
END
CLOSE cur
DEALLOCATE cur

本回答被提问者采纳