Solved

to create temple table

Posted on 2006-11-03
4
606 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 500 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

820 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