sql一列变多行

编写函数

create function dbo.f_str(@FlowNo varchar(10)) returns varchar(800)
as
begin
    declare @str varchar(8000)
    set @str = ''
    select @str = @str + ',' + cast(s3value as varchar) from N81VOLUME where FlowNo = @FlowNo
    --set @str = right(@str , len(@str) - 1)
    --print @str
    return (@str)
end
go

 

--调用函数
select  FlowNo ,  dbo.f_str(FlowNo) as s3value from N81VOLUME
where  lotno='30309663090'--FlowNo='0001NC' --operatedate>= '2010-08-09 ' and operatedate<='2010-08-11' and lotno='30309663090' and
group by FlowNo