如何将存以下储过程改为函数，分不多，帮帮忙了！！
CREATE PROCEDURE sp_businessNumberChat
@starttime datetime,
@endtime datetime

AS

declare @tempTable table(businessId int,businessname varchar(50),subbusinessid int,business_subname varchar(50))

insert into @tempTable (businessid,businessname,subbusinessid,business_subname)
select b.businessid,b.business_name,sub.subbusinessid,sub.business_subname
from business_typemain b,business_type sub
where b.businessid=sub.businessid

insert into @tempTable (businessid,businessname,subbusinessid,business_subname)
select businessid,business_name,0,' '
from business_typemain
where businessid not in (select businessid from business_type)

declare business cursor for
select businessid,subBusinessid,businessname,business_subname from @tempTable
open business

declare @tempNumber table(business_name varchar(50),business_subname varchar(50),n int)

while 1 = 1
begin
declare @bid int
declare @subid int
declare @bname varchar(50)
declare @subname varchar(50)

fetch next from business into @bid,@subid,@bname,@subname
if @@fetch_status <> 0
break

insert into @tempNumber(business_name,business_subname,n)
values(@bname,@subname,0)

insert into @tempNumber(business_name,business_subname,n)
select @bname,@subname,1
from archive
where jointime <=@endtime and jointime>=@starttime and CAST(SUBSTRING(registerid, 1, 2) AS int)=@bid and CAST(SUBSTRING(registerid, 3, 2) AS int)=@subid

end

close business
deallocate business

select business_name,sum(n) as num
from @tempNumber
group by business_name






GO


[解决办法]
应该可以

SQL code

CREATE FUNCTION sp_businessNumberChat( @starttime datetime,@endtime datetime)RETURNS @table table (    business_name varchar(50),    num int) AS begin  declare @tempTable table(businessId int,businessname varchar(50),subbusinessid int,business_subname varchar(50))  insert into @tempTable (businessid,businessname,subbusinessid,business_subname)  select b.businessid,b.business_name,sub.subbusinessid,sub.business_subname  from business_typemain b,business_type sub  where b.businessid=sub.businessid  insert into @tempTable (businessid,businessname,subbusinessid,business_subname)  select businessid,business_name,0,' '  from business_typemain   where businessid not in (select businessid from business_type)  declare business cursor for  select businessid,subBusinessid,businessname,business_subname from @tempTable  open business  declare @tempNumber table(business_name varchar(50),business_subname varchar(50),n int)  while 1 = 1  begin  declare @bid int  declare @subid int  declare @bname varchar(50)  declare @subname varchar(50)  fetch next from business into @bid,@subid,@bname,@subname  if @@fetch_status <> 0  break  insert into @tempNumber(business_name,business_subname,n)  values(@bname,@subname,0)  insert into @tempNumber(business_name,business_subname,n)  select @bname,@subname,1  from archive  where jointime <=@endtime and jointime>=@starttime and CAST(SUBSTRING(registerid, 1, 2) AS int)=@bid and CAST(SUBSTRING(registerid, 3, 2) AS int)=@subid  end   close business deallocate businessinsert into @table select business_name,sum(n) as num from @tempNumber group by business_namereturnend
------解决方案-------------------- 
 
SQL code
SET NOCOUNT ON;GOIF OBJECT_ID('sp_businessNumberChat')IS NOT NULLDROP FUNCTION sp_businessNumberChatGOCREATE FUNCTION sp_businessNumberChat( @starttime datetime,@endtime datetime)RETURNS @table table (    business_name varchar(50),    num int) AS begin  declare @tempTable table(businessId int,businessname varchar(50),subbusinessid int,business_subname varchar(50))  insert into @tempTable (businessid,businessname,subbusinessid,business_subname)  select b.businessid,b.business_name,sub.subbusinessid,sub.business_subname  from business_typemain b,business_type sub  where b.businessid=sub.businessid  insert into @tempTable (businessid,businessname,subbusinessid,business_subname)  select businessid,business_name,0,' '  from business_typemain   where businessid not in (select businessid from business_type)  declare business cursor for  select businessid,subBusinessid,businessname,business_subname from @tempTable  open business  declare @tempNumber table(business_name varchar(50),business_subname varchar(50),n int)  while 1 = 1  begin  declare @bid int  declare @subid int  declare @bname varchar(50)  declare @subname varchar(50)  fetch next from business into @bid,@subid,@bname,@subname  if @@fetch_status <> 0  break  insert into @tempNumber(business_name,business_subname,n)  values(@bname,@subname,0)  insert into @tempNumber(business_name,business_subname,n)  select @bname,@subname,1  from archive  where jointime <=@endtime and jointime>=@starttime and CAST(SUBSTRING(registerid, 1, 2) AS int)=@bid and CAST(SUBSTRING(registerid, 3, 2) AS int)=@subid  end   close business deallocate businessinsert into @table select business_name,sum(n) as num from @tempNumber group by business_namereturn @tableendgo