--用临时表啊
CREATE PROCEDURE ComputeRiPHBB(@strBDate varchar(10),@strEDate varchar(10))
AS
Begin
Create table #(.....)
....
INSERT INTO #(...) values(...)select * from #
End
CREATE PROCEDURE ComputeRiPHBB(@strBDate varchar(10),@strEDate varchar(10))
AS
Begin
Create table #(.....)
....
INSERT INTO #(...) values(...)select * from #
End
CREATE FUNCTION ComputeRiPHBB(@strBDate varchar(10),@strEDate varchar(10))
RETURNS @tempRiPHBB table(id int)
as...
insert @tempRiPHBB ...
...RETURN
go