SQL Server Loop Insert Column

drop table #temp

Select Name,identity (int,1,1) as ID

Into #temp

From syscolumns

WHERE id = (

Select ID from sysobjects

where xtype= ' u ' and name = ' sheet ')

and name not in (' F1 ')

DECLARE @i int, @totalcount int

Set @i= (select Max (ID) from #temp)

SELECT * FROM #temp

DECLARE @sql varchar (4000)

DECLARE @s_tablename varchar (20)

DECLARE @s_columnsnname varchar (20)

CREATE TABLE test_20170822 (F1 varchar ($), F2 float)

While @i< @totalcount

Begin

Set @s_columnsnname = (select name from #temp where ID [email protected])

Set @sql = ' INSERT INTO test_20170822 (F1,F2)

Select F1, ' [email protected]_columnsnname+ ' from sheet '

EXEC sp_executesql @sql

Set @[email protected]+1

End

SQL Server Loop Insert Column