declare @Ids varchar(2000) set @Ids='' select @Ids=@Ids+','+cast(id as varchar(10)) from ( select top 10 id from [table2]) as a exec('insert table1([key],[date],id1,id2,...,id10) values (1,''2003-3-15'','+@Ids)
declare @Ids varchar(2000) set @Ids='' select @Ids=@Ids+','+cast(id as varchar(10)) from ( select top 10 id from [table2]) as a exec('insert table1([key],[date],id1,id2,...,id10) values (1,''2003-3-15'','+@Ids+')')
declare @Ids varchar(2000) set @Ids='' select @Ids=@Ids+','+cast(id as varchar(10)) from ( select top 10 id from [table2]) as a exec('insert table1([key],[date],id1,id2,...,id10) values (1,''2003-3-15'','+@Ids+')')
set @Ids=''
select @Ids=@Ids+','+cast(id as varchar(10)) from ( select top 10 id from [table2]) as a
exec('insert table1([key],[date],id1,id2,...,id10) values (1,''2003-3-15'','+@Ids)
set @Ids=''
select @Ids=@Ids+','+cast(id as varchar(10)) from ( select top 10 id from [table2]) as a
exec('insert table1([key],[date],id1,id2,...,id10) values (1,''2003-3-15'','+@Ids+')')
set @Ids=''
select @Ids=@Ids+','+cast(id as varchar(10)) from ( select top 10 id from [table2]) as a
exec('insert table1([key],[date],id1,id2,...,id10) values (1,''2003-3-15'','+@Ids+')')