Hi all

i am trying to put data into a table from a query...

i can use a the select/into method...which works...however i need to continually delete/recreate the table...which is not efficient given that i want to do this every ten seconds..(a trading application)
(select into only works if creating the destination table..)

i have been trying to do this with insert/nested select query..however insert only allows scalar values...

ideally i would like to just erase the table every 10 seconds and use insert or something similar....

any suggestions...thanks for any input

mch

would creating a temp table help

select productname as products,
unitprice as price
,(unitprice * 1,1) as Tax
into #PriceTable
from products

to view results
select * from #priceTable

thanks...temp table was the answer...amazing how these things are easier the next day...

i am using the format

insert into tablename
select * from table where...group by....

then delete table and use again...

thanks