改子查询这样,试下(SELECT top 1 m_tantou.tantou_mei AS EXPR5
FROM t_bukken LEFT OUTER JOIN
m_tantou ON t_bukken.company_cd = m_tantou.company_cd AND
t_bukken.eigyou_tantou_naibu_no = m_tantou.tantou_naibu_no
WHERE m_tantou.tantou_naibu_no = 2),
FROM t_bukken LEFT OUTER JOIN
m_tantou ON t_bukken.company_cd = m_tantou.company_cd AND
t_bukken.eigyou_tantou_naibu_no = m_tantou.tantou_naibu_no
WHERE m_tantou.tantou_naibu_no = 2),
function dbo.c_str(@tantou_naibu_no int)
returns varchar(8000)
as
begin
declare @s varchar(8000)
set @s=''
SELECT @s=@s+m_tantou.tantou_mei AS EXPR5
FROM t_bukken LEFT OUTER JOIN m_tantou
ON t_bukken.company_cd = m_tantou.company_cd
AND t_bukken.eigyou_tantou_naibu_no = m_tantou.tantou_naibu_no
WHERE m_tantou.tantou_naibu_no =@tantou_naibu_no
return stuff(@s,1,1,'')
end然后,查询的时候这样select ...,dbo.c_str(m_tantou.tantou_naibu_no),...
....
.....
end
lsxaa(小李铅笔刀) :很感谢你的帮助,不管怎样用函数确实是中解决的途径。