declare @s varchar(8000)
set @s=''
select @s=@s+left(b.b_mobile,5)+',' from sale a left join salebuy b on a.id=b.s_id
where a.thedate = 今天的日期的所有数据print @s
set @s=''
select @s=@s+left(b.b_mobile,5)+',' from sale a left join salebuy b on a.id=b.s_id
where a.thedate = 今天的日期的所有数据print @s
returns varchar(1000)
as
begin
declare @r varchar(1000)
set @r=''
select top 5 @r=@r+b_mobile from salebuy
return(@r)
end
goselect id,dbo.f_merg(id) as s_id from sale where datediff(day,thedate,getdate())=0
as
set nocount on
select left(b_mobile,5) from salebuy where s_id = (select id from sale where
thedate between getdate and dateadd(hour,23,dateadd(minute,59,getdate())) )