Re: insert into temp table based on if condition
- From: Serge Rielau <srielau@xxxxxxxxxx>
- Date: Wed, 12 Apr 2006 15:23:57 -0400
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
.
- Follow-Ups:
- Re: insert into temp table based on if condition
- From: Chris Fulstow
- Re: insert into temp table based on if condition
- References:
- Prev by Date: Re: SQL Query Question
- Next by Date: Re: insert into temp table based on if condition
- Previous by thread: Re: insert into temp table based on if condition
- Next by thread: Re: insert into temp table based on if condition
- Index(es):
Relevant Pages
|
