sql函数中怎么将表格形式转化为字符串形式
ALTER function [dbo].[F_GTN_GetItemSegmentCode](
@Region varchar(50),
@SaleOrg varchar(50)
)
returns nvarchar(max)
as
begin
--
--declare @Region varchar(50)
--declare @SaleOrg varchar(10)
--
--set @Region='HTK'
--set @SaleOrg='HK10'
declare @t table(SegmentCode varchar(50))
declare @segmentvar nvarchar(8000)
insert @t select distinct [SegmentCode] from dbo.GTN_Item where SalesOrgCode=@SaleOrg and RegionCode<>''
for(int i=0;i<@t.rows.count;i++)
{
if(i=0)
@segmentvar=@t.rows[0][0]
else
@segmentvar+=','+@t.rows[0][i]
}
return @segmentvar
--(case when @Region='' then SalesOrgCode=@SaleOrg else RegionCode=@Region))
end