declare @sql1 varchar(8000) declare @sql2 varchar(8000) declare @i int declare @fld1 varchar(20) declare @fld2 varchar(20) declare @fldx varchar(20) select @sql1='select T売上.番号' select @sql2='' select @fld1='日付' select @fld2='数' select @i=0 declare fld_lst cursor for select distinct convert(varchar,日付,111) as 日付 from T売上 order by 日付 open fld_lst while @i<100 begin fetch next from fld_lst into @fld