34,575
社区成员
发帖
与我相关
我的任务
分享
DECLARE @sql VARCHAR(8000)
SET @sql = 'select A 台号'
SELECT @sql = @sql + ',max(case B when ''' + LTRIM(RTRIM(B))
+ ''' then C else null end) ['+LTRIM(RTRIM(B))+']'
FROM ( SELECT DISTINCT
B ,
D
FROM fl
) AS a
ORDER BY D
SET @sql = @sql + ' from fl where 日期=' + QUOTENAME('2012-5-7', '''')
+ ' group by A'
print(@SQL)
DECLARE @sql VARCHAR(8000)
SET @sql = 'select A 台号'
SELECT @sql = @sql + ' ,max(case B when ''' + B
+ ''' then C else null end) ['+B+']'
FROM ( SELECT DISTINCT
B ,
D
FROM fl
) AS a
ORDER BY D
SET @sql = @sql + ' from fl where 日期=' + QUOTENAME('2012-5-7', '''')
+ ' group by A'
print(@SQL)
declare @sql varchar(8000)
set @sql = 'select A AS 台号'
select @sql = @sql + ' , max(case B when ''' + B + ''' then C else NULL end) [' + B + ']'
from (select distinct B,D from 分类营业统计_主 ) as a order by D set @sql = @sql + ' from 分类营业统计_主 where E between'+quotename('" & CStr(DTPicker5.value) & "','''')+'AND '+quotename('" & CStr(DTPicker6.value) & "','''')+' group by A' print(@SQL)
执行一下,贴结果,另外回复请引用