1、表ec_chengji中包含多个字段,其中有以下几个字段
2、希望实现,满足条件的效果(安全文明侧中IBK=1的显示 CXYBH,DTIME进行短日期格式拼接)
=================实现方法===================
1、在SQL2000中只能借助函数实现 函数getbukaotime
ALTER FUNCTION dbo.getbukaotime(@cxybh varchar(50),@ckemu varchar(50))
RETURNS varchar(8000)
AS
BEGIN
DECLARE @str varchar(8000)
SET @str = ''
SELECT @str = @str + ',' + CONVERT(varchar(100), dtime, 23) FROM ec_chengji WHERE cxybh=@cxybh and ibk=1 and ckemu=@ckemu
RETURN STUFF(@str, 1, 1, '')
END
2、调用
select cxybh, bukaotime= dbo.getbukaotime(cxybh,'安全文明测试') FROM ec_chengji GROUP BY cxybh