写一个函数来实现
return nvarchar(500)
as
begin
declare @result
set @result=''
select @result=@result+soccor+',' from table where tingname='李思'
set @result=left(@result,len(@result)-1)
return @result
end
在其它存储过程中传入tingname的值就可以
return nvarchar(500)
as
begin
declare @result
set @result=''
select @result=@result+soccor+',' from table where tingname='李思'
set @result=left(@result,len(@result)-1)
return @result
end
在其它存储过程中传入tingname的值就可以
select tingname,max(soccor) as month1,null as month2,........null as month12
where fldcmonth = '1月'
group by tingname
union all
select tingname,nullas month1,max(soccor) as month2,........null as month12
where fldcmonth = '2月'
group by tingname
........uinon 12 个...
--最后出来的记录应该是你要的....