Reply to Re: insert into temp table based on if condition
Posted by Serge Rielau on 04/12/06 22:23
select * into #tmp_table
from products p
left join
sales s on p.p_data = s.p_data
where s.p_data IS NOT NULL OR
@condition <> 0
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab