select distinct stuff((select ','+A.zType from (select distinct desc + '/' + CAST( qty as nvarchar(20)) zType from matl_mst WHERE job = @job ) A FOR xml PATH('')), 1, 1, '') as zType ,job from matl_mst where job = @job
注释:@job 变量
STUFF 删除函数
select distinct stuff((select ','+A.zType from (select distinct desc + '/' + CAST( qty as nvarchar(20)) zType from matl_mst WHERE job = @job ) A FOR xml PATH('')), 1, 1, '') as zType ,job from matl_mst where job = @job
注释:@job 变量
STUFF 删除函数