No need to use temp table. Since these are static values, u can assign them directly to the columns satisfying the conditions.
Regards!...
Sangs
Last Activity: Feb 12 '07, 10:49 AM
Joined: Jan 8 '07
Location:
-
Thanks Everyone! The Problem has been resolved....Leave a comment:
-
You can first insert values for the col4 using the same select query which may insert multiple multiple rows into tableA. Later you can update other columns with the static values mentioned in your query.
The query will be like this:
insert into tableA
(col4)
select
favorite_movie
from tableB
where movietype = 'SciFi'
and (moviedate=1965 or 1966)
and B&W !=1
...Leave a comment:
-
Yes, the tables mentioned have indexes. But i want to know is there any other way to improve the performance of this query....Leave a comment:
-
How to improve the performance of a query?
I have a table called DMPD_Product_Lo okup_Dom. It is a lookup table which contains values for certain fields of other tables in the database.
This takes long time to run.
Is there any way to improve performance of this query ??
SELECT
BNAD.Benefit_Ad min_Cat_CD AS 'AdminCategory' ,
DOM1.Value_Desc ription AS 'AdminCategoryD esc',
BNAD.Benefit_Co mponent_Name_CD...
No activity results to display
Leave a comment: