select
convert(varchar(100),count(case when day(AcceptDate) = 1 then AcceptNum end)) + '1(' + cast(DATEPART(dw, AcceptDate) as varchar) + ')'
from AcceptRefer
convert(varchar(100),count(case when day(AcceptDate) = 1 then AcceptNum end)) + '1(' + cast(DATEPART(dw, AcceptDate) as varchar) + ')'
from AcceptRefer
你的sql是错误的.
declare @a varchar(2)
SET @A='FF'
exec('select 23434 as '''+'1('+@a+')''')
/*
1(FF)
-----------
23434
*/
set @sql='select
count(case when day(AcceptDate) = 1 then AcceptNum end) as '''+
'1(' + cast(DATEPART(dw, AcceptDate) as varchar) + ')''
from AcceptRefer'
exec(@sql)
count(case when day(AcceptDate) = 1 then AcceptNum end) as '[1(' + cast(DATEPART(dw, AcceptDate) as varchar) + ')]'
from AcceptRefer
vivianfdlpw()
语法错误!