Generating an insert statement

[jjlbmcnews]

I need to generate a number of insert statements using the results of a select statement. Basically I have the following statement -

insert into table1
select table1.column1, value1
from table1
where table1.column2=value2
and table1.column1 not in (select table1.column1
from table1 where table1.column2=value1)

The above query works fine if I manually specify value1 and value2 but I need this to generate the values automatically as I need to do this for several hundred values!

 

[aftertaf]

do it with stored procedures...

separate each logical unit and put each in a SP..

that way you can call one from within another and send it parameters.....
a bit rusty on HOW exactly to do it... but if you see what i mean.........

Aftertaf

"Solutions are not the answer." - Richard Nixon

 

[jjlbmcnews]

Ah, did I mention that this was in Oracle?

 

[JamesLean]

No, but you should have done! This is a SQL Server forum - you need to post this question in an Oracle forum.

--James

 

[aftertaf]

loooool
never mind


Aftertaf

"Solutions are not the answer." - Richard Nixon