22,206
社区成员
发帖
与我相关
我的任务
分享
--以前的SQL
select top 100 memberid,companyname,dbo.fn_Merge1(member.memberid) as jobname
from member
where companyname<>''
and isdelete=0
order by ordertime desc
CREATE function [dbo].[fn_Merge1](@id int)
returns varchar(1000)
as
begin
declare @r varchar(1000)
set @r=''
select top 3 @r=(@r+','+Convert(varchar,JobID)+'|'+jobName) from Job where Memberid=@id order by jobid desc
return stuff(@r,1,1,'')
end
order by ordertime desc