to create temple table

Hi I want to create a temp table and i am doing it as follow

Create Table #t_i_ifh
(
code char(2),
description varchar(30),
short_description varchar(15),
parent_code varchar(6),
level_number int)

then i am inserting values in that table

which is Insert in tablename(fieldnames)
select '''''''''''''''''''''
union all select''''''''''''''''''



is this the right way as from this table i have to update the other table

can you please help




Regards,


Ammar Tahir
ammartahir1978Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
Insert into tablename(fieldnames)
select '''''''''''''''''''''
union all select''''''''''''''''''

0
 
Aneesh RetnakaranDatabase AdministratorCommented:
still not clear what you are trying to do ?

You can do it in the same way u mentioned
0
 
ammartahir1978Author Commented:
but when i run it it gives an error


INTERNAL QUERY PROCESSOR ERROR: THE QUERY PROCESSOR RAN OUT OF STACK SPACE DURING QUERY OPTIMIZATION
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
0
All Courses

From novice to tech pro — start learning today.