Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

to create temple table

Posted on 2006-11-03
4
Medium Priority
?
617 Views
Last Modified: 2008-01-09
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
0
Comment
Question by:ammartahir1978
  • 3
4 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 1000 total points
ID: 17868553
Insert into tablename(fieldnames)
select '''''''''''''''''''''
union all select''''''''''''''''''

0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17868561
still not clear what you are trying to do ?

You can do it in the same way u mentioned
0
 

Author Comment

by:ammartahir1978
ID: 17868587
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
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17878519
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question