摘要： if object_id('tempdb..#tb') is not null drop table #tbselect fworkno,convert(varchar(100),date,112) date,classes_id into #tb from ck_scheduling where date<'2012-10-07'declare @f varchar(max), @sql varchar(max)set @f = stuff(( select distinct ',[' + convert(varchar(10),date 阅读全文