摘要：列：RecYear(int),RecMonth(int),RecDay(int),T0000,T0010,T0020,T0030,T0040..将2012-5-12的数据与2012-5-11的数据组合declare @sql as nvarchar(max)declare @selectstr as nvarchar(max)set @selectstr = 'a.RecYear,a.RecMonth,a.RecDay,'declare @i as intset @i=0while @i<=50begin--print right('0000'+cast( 阅读全文