一个sql，希望大家帮忙！

[hanfey]

61 a001007 MFG
61 a001007006 PEI
61 a001007006005 WAT

>>>>>>结果
61 mfg/pet/wat
or
61 a001007006005 mfg/pet/wat

大家帮忙哦！

[HawaiiLeo]

CrazyFor(蚂蚁) 回答得太详细了。

[hanfey]

thanks a million!
ok,now

[huntsman]

declare @cc varchar(100)
select @cc = ''
select @cc = @cc + cast(tid as varchar)+'/' from ttt
select @cc = left(@cc,len(@cc)-1)
print @cc

[pengdali]

create function getstr(@content varchar(20))
returns varchar(2000)
as
begin
declare @str varchar(2000)
set @str=''
select @str=@str+'/'+rtrim(字符求和列) from 表
where 主键列=@content
set @str=right(@str,len(@str)-1)
return @str
end
go

语句：
select 主键列,dbo.getstr(主键列) from a group by 主键列

[CrazyFor]

declare @cc varchar(100)
select @cc = ''
select @cc = @cc + cast(tid as varchar)+'/' from ttt
select @cc = left(@cc,len(@cc)-1)
select 61,@cc
union
select 'or'
union
select '61',max(len(col2)),@cc from ttt

[pengdali]

蚂蚁~~~哈哈。。。。。连or 都写上去了，哈哈。。。。。。

我也老是看错题目，哈哈。。。

[CrazyFor]

呵呵~~~~我以为他就是要这样的结果，哈哈哈~~~~