1,建自定义函数
create function getstr(@Category Nchar(4000))
returns Nvarchar(4000)
as
begin
declare @str Nvarchar(2000)
set @str=N''
select @str=@str+rtrim(xmmc)+N'|' from table1
where Category=@Category
if @str<>N''
set @str=left(@str,len(@str)-1)
return @str
endGO2,
select Category, dbo.getstr(Category) as Score from table1 group by Category
愉快的登山者 ⊙
◢◣◢◣◢◣
create function getstr(@Category Nchar(4000))
returns Nvarchar(4000)
as
begin
declare @str Nvarchar(2000)
set @str=N''
select @str=@str+rtrim(xmmc)+N'|' from table1
where Category=@Category
if @str<>N''
set @str=left(@str,len(@str)-1)
return @str
endGO2,
select Category, dbo.getstr(Category) as Score from table1 group by Category
愉快的登山者 ⊙
◢◣◢◣◢◣
我用的|是来 代用表格线的
中一个Score就是一项,而不是由|链接,能实现吗
1,建自定义函数
create function getstr(@Category Nchar(4000))
returns Nvarchar(4000)
as
begin
declare @str Nvarchar(2000)
set @str=N''
select @str=@str+rtrim(xmmc)+' ' from table1
where Category=@Category
if @str<>N''
set @str=left(@str,len(@str)-1)
return @str
endGO2,
select Category, dbo.getstr(Category) as Score from table1 group by Category
要变成数据项是Score1,Score2……很多的阿