在SQL SERVER 2000,有时会有这种情况:
1.表CyOne有数据如下
FID FDate FCode FName
1 2008-01-01 01 张三
2 2008-01-01 02 李四
3 2008-01-02 03 赵五
4 2008-01-02 04 钱六
2.要得到如下结果
FDate FRemark
2008-01-01 01:张三;02:李四
2008-01-02 03:赵五;04:钱六
3.SQL语句
Code
create function StrSum(@FDate datetime)
returns varchar(500)
as
begin
declare @str varchar(500)
set @str=''
select @str=@str+FCode+':'+FName+';' from CyOne where FDate=@FDate
return @str
end
select FDate,dbo.StrSum(FDate) from CyOne group by FDate
create function StrSum(@FDate datetime)
returns varchar(500)
as
begin
declare @str varchar(500)
set @str=''
select @str=@str+FCode+':'+FName+';' from CyOne where FDate=@FDate
return @str
end
select FDate,dbo.StrSum(FDate) from CyOne group by FDate