yes, you cannot do this.
You either need separate INSERT statements for each record or use the approach below (more code tho):
insert into #T_i_IFH (code,description,short_description,parent_code,level_number)
SELECT '01','MENS','MENS','53',2
UNION ALL
'01','MENS','MENS','54',2
UNION ALL ... etc etc

If you were inserting into a permanent table instead of a temp table, you could do a bulk import of the data from a CSV/spreadsheet file straight in to the table (Right click the table in EM -> Import Data)

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…