22,209
社区成员
发帖
与我相关
我的任务
分享
declare @sql nvarchar(max)
select @sql=isnull(@sql,'')+',max(case when NdataTime='''+convert(varchar,NdataTime,25)+''' and isnull([imagepath],'''')='''+rtrim(isnull(imagepath,''))+''' then NdataTime else null end)打卡'+rtrim(row)
+',max(case when NdataTime='''+convert(varchar,NdataTime,25)+''' and isnull([imagepath],'''')='''+rtrim(isnull(imagepath,''))+''' then [imagepath] else null end)图像'+rtrim(row)
from(
select row=row_number()over(order by getdate()),NdataTime,[imagepath] from tb group by NdataTime,[imagepath]
)t
print @sql
exec('select RegNumb,[name]'+@sql+' from tb group by RegNumb,[name]')